p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Combo Boxes (http://p2p.wrox.com/showthread.php?t=37193)

nbuckwheat January 14th, 2006 10:26 AM

Combo Boxes
[?]I have a form with two tab controls. The first tab control contains a combo box of job names, various information is displayed in subforms that this particular job requires.

Tab two has the same job options but not in a combo box but by scrolling through records. This tab only shows competencies as tab one does with a difference of being able to select a specific employee from a list box. When the employee is selected his matching as well as overall competencies are displayed.

My problem . . .when I select a job from tab one's combo box and all competencies are displayed and I go to tab two, the competencies are carried over and displayed on the subform on tab two.

How can I open tab two without information from tab one passing?

Basically, I need both tabs to work independently.

Thanks in advance.

RuralGuy January 15th, 2006 09:26 AM

You need to base the information on Tab 1 on a different query than tab 2. The queries can still reference the same table but they need to be independant of one another.

HTH RuralGuy (RG for short) acXP WinXP Pro

All times are GMT -4. The time now is 04:02 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.