synchronizing forms on a tab control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 02 Mar 2008 02:03 GMT

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?

Reply to this Message

Al Campagna - 02 Mar 2008 02:53 GMT

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.

Signature

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."

>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?

Reply to this Message