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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tab order stops at last field 6
Requery on a Tab Control - OnClick 3
How to disabe the Tab Command to go next Form 1
Tabbing between a main form and a subform 1
unhiding and rehide tab on tabbed form 1
Tab control & formatting 12
Double Click from One Tab form to the next 6
tabbed forms - tab 3 link to tab 2 1

Back
Top