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.

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