I have an Access interface to a network SQL database. The form is set to "Dynaset (Inconsistent Updates)" to allow for a complex underlying SQL query.
After someone enters data in a field, it is supposed to open another form to allow them to choose additional info to insert into the record. But it keeps saving the record and moving to a new record as soon as the Sub ends (but after the new form is opened) which causes my new form to insert data in the wrong record. As soon as the VBA code executes "End Sub" then it moves.
Any ideas?
After someone enters data in a field, it is supposed to open another form to allow them to choose additional info to insert into the record. But it keeps saving the record and moving to a new record as soon as the Sub ends (but after the new form is opened) which causes my new form to insert data in the wrong record. As soon as the VBA code executes "End Sub" then it moves.
Any ideas?