Access 2010 trouble with tabs
Hi, Experts -
I have a simple stand-alone Access 2010 database (.mdb - using 2003 compatibility because we have a few stragglers who have not yet been upgraded). The users like tab controls. So, I created a form with sub-forms on each tab. So far, just two tabs each with their own sub-form.
On main form (first tab) - a combo box displays all employees. Once an employee is selected, Sub-form1 displays the fields from a query executed with code tied to the AfterUpdate event on the combo box. All is fine there.
But the second tab's sub-form2 - which is supposed to display rows from a second query...also executed in the same code on the AfterUpdate event - displays nothing at all. In the header portion of Sub-form2, I have the following Iif stmt, which is referencing fields in the query executed:
=IIf([ID]<>"",[EEName],"No
What am I doing wrong?
I have a simple stand-alone Access 2010 database (.mdb - using 2003 compatibility because we have a few stragglers who have not yet been upgraded). The users like tab controls. So, I created a form with sub-forms on each tab. So far, just two tabs each with their own sub-form.
On main form (first tab) - a combo box displays all employees. Once an employee is selected, Sub-form1 displays the fields from a query executed with code tied to the AfterUpdate event on the combo box. All is fine there.
But the second tab's sub-form2 - which is supposed to display rows from a second query...also executed in the same code on the AfterUpdate event - displays nothing at all. In the header portion of Sub-form2, I have the following Iif stmt, which is referencing fields in the query executed:
=IIf([ID]<>"",[EEName],"No
What am I doing wrong?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jeff (aka OGSan)