I want to have one form that I can call from a switchboard and filter for
several people using a macro.  I’m using Access 2007 and my setup is as
follows:

SWITCHBOARD:
This is a manually designed switchboard where I’ve put a tab control with 2
tabs titled “Input Forms” and “Reports”.  On the “Input Forms” tab I have
placed a combo box named “cboExpItems”.  This is a drop-down box which
displays employee names from a table.  I want to select a name and using an
“AfterUpdate” event I want to run the following macro which will refer back
to “cboExpItems” for the name of the employee to filter the form.

MACRO:
Name:  ExpItemsSpPerson
   Action:    OpenForm
       FormName:    Expense Items
       View:    Form
       Where Condition: [RequestedBy]=[Forms]![Main
Switchboard]![cboExpItems]
       Window Mode:    Normal

This is not working.

When I select the employee name in the “cboExpItems” drop-down box I get
“Enter Parameter Value” with the above “[RequestedBy]=[Forms]![Main
Switchboard]![cboExpItems]“ shown.

Is my “Where Condition” statement not correct since I’m using a tab?  I’ve
used this setup before and it has worked fine.  I’m new to Access 2007 so
maybe something has changed.  Thanks for your help.