How to subtract values from textbox in form from Field in table (Access '07 VBA)? -
i developing canteen transaction system in ms access 2007. in "add food item:" form, have series of textboxes , comboboxes, button, "add item" , listbox. names of text , combo boxes follows :
textbox names: txtrate, txtqty
combobox names: cbxicode, cbxitems
on click of add item button, selected item quantity, rate etc. gets tranferred listbox. (i asked asked transfer question here)
now, in tblitems, there "qtyavailable" field indicates available quantity of existing food items. how i:
- subtract quantity of food item user enters qtyavailable field in tblsampledata?
advanced appreciated.
thanks,
s sandeep
write query def performs task on table. can set parameters in query def enclosing them in square brackets. when ms access not recognize name in square brackets, prompt user value.
once works correctly, search net vba examples on using ado or dao copy of query def in memory, set parameter value(s), , execute query. recordset select, execute insert, update, , delete
Comments
Post a Comment