Synchronizing 2 subforms on a tab control

[Guest]

I have a form that has 2 subforms on a tab control. The 2 subforms have
similar record sources. When I make changes on tab 1 - the information
should reflect on tab 2 if the user is on that record (i.e, the user goes to
tab 2 and uses dropdown to move to John Doe's record. Then moves to tab 1
and adds a child to John Doe's family. Then moves back to Tab 2 which should
still be on John doe's record. Tab 2 should now show the new child entered).
I can get the subform from tab 2 to requery but then it movees to the first
record in the recordsource instead of the actual record that is still
selected in the dropdown.

I can put a button on tab 2 which refreshes and resynchs up the records to
the one that is selected on the drop down. Hope that makes sense.

 

[Al Campagna]

Alex,
Check out Stephen Leban's SetGetSB
http://www.lebans.com/setgetsb.htm
It allows a subform to be requeried, and returns the sub to the same record and
position as before the requery.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."