Sync Tabbed Form

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
 
A

Arvin Meyer [MVP]

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

Tabbed Forms 2
Tabbed Form Design 1
Tabbed Control Form 1
Multi-record tabbed subform question 1
Print tabbed form 7
Requery tabbed documents 2
Best practice question: Unbound form to update multiple tables 4
Change existing form to tabbed form 1

Top