update table with form

[dolfan1873]

i have a main form that is used for the database, on one of the check boxes i have a procedure that opens a form with some more check boxes, i made the second form off of the same table, i want the second form to update the original table, every time i try this when i try to move to another record of close the database, i get a window that says that a record has been updated by someone and do you want to save it, how do i get it to save the data from the second form to the main table. all i want is for the second form data to be saved to the table when it is checked, i can't have another popup asking if you want to save.


thanks for any help

 

[sfreeman]

When you check the box on the first form, which executes code to open a second form that is based upon the same table as the first, it may see the recordset as unsaved, meaning even though you clicked the box on the first form, the record was never actually saved.

Try adding code to the first routine that will test the form to make sure the record is saved before it opens the next form.