Form saves and moves to next record when sub ends (1 Viewer)

[DocNice]

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?

 

[RuralGuy]

Do you have your form set to "Cycle Current Record" on the Other tab of the properties sheet?

 

[DocNice]

It's a bandaid solution, but that works for me. Thanks!

 

[RuralGuy]

Are you opening the "Other" form as acDialog? That will stop the code in your 1st form.