dominicdunmow
Technical User
I have a form and a subform linked with a parent/child relationship on the ID field.
When I open the main form all is well, I can toggle through the records and the subform records change accordingly.
However...
When I update some of the fields in the subform (which consists of a combobox and some text boxes) the synchronisation is lost.
When I toggle through recrods the subform remains on the record I have updated while the main form changes.
If I move the cursor back to the combobox which is the first control in the Tab order then I toggle again correctly through the records.
This means I have to ensure users of the database always to go back to a particular filed/control in the subform before moving on. I presume something is wrong here, but cannot fathom what.
Can anyone help please?