synchronizing forms on a tab control

[Steve]

I have placed a customer listbox on page one of a tab control. On page two I
have a form bound to a customer table. When I select a customer in the
listbox and click on the tab for page two I would like the form to show info
for that customer. how can I synchronize the two?

 

[Al Campagna]

Steve,
I would assume that your customer table has a key field like CustID.
Use the combo (ex. cboCustID) to select a legitimate CustID.
Make cboCustID the Parent, and CustID in the subform the Child.
Use the AfterUpdate event of cboCustID to Requery the subform, whenever
the value of cboCustID changes.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

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