Make pg2 of a TbCntrl reflect information based on pg1 selection

[b31luv]

Is this possible. I discovered the tab control and I would love to use it. My database had several different forms with subforms and were linked based on selections on the forms. I removed all forms and subforms and made one form using a tbCntrl. When the main form is opened the first page of the tab control is visible. There is a combo box on the main form the user uses to select the Site/Plant they are dealing with. After the selection is made Page 1 updates showing all of the Areas associtated with that site. The user must at this point select an area within the Site/Plant before they can do anything else. After they select the area then they can proceed to the next tab. The next tab list all equipment at the Site/Plant located in the area they selected. Well, this is how it is suppose to work. Right now the Equipment tab shows all equipment located throughout the entire city. Someone suggested using requery. Where? and How? Every place I've tried to insert this nothing happens. Also, I'm not even sure how this should be written.

 

[ZOR]

You could put a subform on page 2 of the tab control. It could contain the related details of the mainforms table. When a record is selected on the mainform the subform would change to reflect the related data providing you have setup relationships, etc. Before you try ading a subform to the tab page, make sure you have clicked on the tab page to tell Access where you are placing it otherwise it will put it showing on all tabs.