|Figure 1: Intellisense displaying a list of valid parameter values for VIEW.|
DoCmd.OpenForm "frmEmployees", acFormDS, , "position = 'manager'"
DoCmd.Close acForm, Me.Name
NB the DoCmd.Close statement simply closes the switchboard so it does not get in the way once our employees form opens.
|Figure 2: The new updated switchboard from last week.|
The code above it is written behind the ctlManagers button's (top) OnClick Event.
|Figure 3: frmEmployees displayed in Datasheet View with WhereCondition applied.|