O
Opal
Running Access 2003 and trying to open a form with the following:
If Len([cboEmployee] & "") <> 0 And IsNull(Me.FromDate) And
IsNull(Me.ToDate) Then
strWhere = "EmployeeID =" & Employee
DoCmd.OpenForm "frmReflection", , , strWhere
End If
And the form opens to a blank record when the combo box has a value.
Even this does the same thing:
If Not IsNull(me.cboEmployee And IsNull(Me.FromDate) And
IsNull(Me.ToDate) Then
strWhere = "EmployeeID =" & Employee
DoCmd.OpenForm "frmReflection", , , strWhere
End If
What am I missing... I think I have been staring at this too
long..... :-(
If Len([cboEmployee] & "") <> 0 And IsNull(Me.FromDate) And
IsNull(Me.ToDate) Then
strWhere = "EmployeeID =" & Employee
DoCmd.OpenForm "frmReflection", , , strWhere
End If
And the form opens to a blank record when the combo box has a value.
Even this does the same thing:
If Not IsNull(me.cboEmployee And IsNull(Me.FromDate) And
IsNull(Me.ToDate) Then
strWhere = "EmployeeID =" & Employee
DoCmd.OpenForm "frmReflection", , , strWhere
End If
What am I missing... I think I have been staring at this too
long..... :-(