Hi...
I have several forms and I need to update an MS Access Database from a form that does not contain the database ref. I've tried this on the form that doesn't contain the record set:
Code:
Patient_Info2.datPrimaryRS.Recordset.UpdateBatch adAffectAll
, but when I go back to the form WITH the record set (Patient_Info2) and select another record I get the error "Operation was Cancel" with the record number that was suppose to be updated in the title of the message box .

If I use my "update record" command button on the Patient_Info2 form it saves it ok (button executes the same code as above) and then I can go to the next record. I need to make this automatic (from my other form) as well as with the command button.

What am I doing wrong???