Multiple Where Command

[UT227]

I'm trying to add a where command to a button. I need it to be multiple wheres. I wrote this and it went straight to the debugger.
DoCmd.OpenForm "frmSchTimeSheet", , , ("EmployeesID=" & Me.cboEmployee And "BeginDate=" & Me.txtBeginDate And "EndDate=" & Me.txtEndDate)
I'm really hoping this is possible.

[UT227]

Figured it out.
DoCmd.OpenForm "frmSchTimeSheet", , , "EmployeesID = forms!frmSchTimeSheet!cboEmployee And BeginDate = forms!frmSchTimeSheet!txtBeginDate And EndDate = forms!frmSchTimeSheet!txtEndDate"

[ssanfu]

Dates and Text require delimiters...
Consider

DoCmd.OpenForm "frmSchTimeSheet", , , "EmployeesID = " & Me.cboEmployee & " And BeginDate = #" & Me.txtBeginDate & "# And EndDate = #" & Me.txtEndDate & "#"

OR

DoCmd.OpenForm "frmSchTimeSheet", , , "EmployeesID = " & forms!frmSchTimeSheet!cboEmployee & " And BeginDate = #" & forms!frmSchTimeSheet!txtBeginDate & "# And EndDate = #" & forms!frmSchTimeSheet!txtEndDate & "#"

-----------------------------------------------------------------
I like to create a string so I can check to ensure the Where clause is properly formed:

Dim strWhere as String

  strWhere = "EmployeesID = " & Me.cboEmployee & " And BeginDate = #" & Me.txtBeginDate & "# And EndDate = #" & Me.txtEndDate & "#"

  Debug.Print strWhere 

  DoCmd.OpenForm "frmSchTimeSheet", , , strWhere

[UT227]

I keep forgetting about that. Thanks.