If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
synchronizing forms on a tab control
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? |
#2
|
|||
|
|||
synchronizing forms on a tab control
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." "Steve" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|