I have an Access form. Eveytime you click on a command button (only if the check box is ticked), I want to be able to update three different fields in three different tables with the values taken from multiple comboboxes. If you think that's too much too ask for, I also want to be able to know how to add and subtract the values selected in the combobox to the values(records) that are presently there in the field. One last thing, the scenario is that I want to be able to have one record/value selected from the combobox in the access form but I want it to take arecord from a different table and update it to another table. I'd love to see some sample code on something similar to this procedure. Very highly appreciated VB lover,
mkeating
