Sync Tabbed Form

  • Thread starter Thread starter smyle
  • Start date Start date
S

smyle

I have a Tabbed form where one of the tabs shows about 20 rows of a table.
Another tab shows a single record from that table with all the fields for
that record.

I want to be able to move from tab to tab and and stay on the same record
(hopefully that's clear).

What is the cleanest approach... any suggestions?

Thanks
 
If the queries for the single record uses the other record as a criteria
like:

[Forms]![FormName]![SubformName].Form![txtID]

where txtID is the Primary Key value showing, then you only need to requery
in the Change event of the Tab control:

[Forms]![FormName]![Subform 2 Name].Form.Requery
 
Back
Top