Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form - Subform, Loss of synchronisation

Status
Not open for further replies.

dominicdunmow

Technical User
Jul 28, 2004
125
CA

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?





 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top