Search Coding

[shall]

Currently I have a search form that has 2 fields First Name & Last Name both in a combo box. First would it be easier to just have the one Box and title it name? Since you can see multiple columns or leave it as is.

The other problem is that when i add the code below to the Click event nothing happens. Whether i fill out the form or leave it blank. Am I missing something?


Dim strWHERE As String
If Len(Me.txtFName & vbNullString) > 0 Then
strWHERE = strWHERE & "[txtFName] =" & Chr(34) & Me.txtFName & Chr(34) & " AND "
End If
If Len(Me.txtLName & vbNullString) > 0 Then
strWHERE = strWHERE & "[txtLName] =" & Chr(34) & Me.txtLName & Chr(34)
End If

If Right(strWHERE, 5) = " AND " Then
strWHERE = Left(strWHERE, Len(strWHERE) - 5)
End If
Debug.Print strWHERE
DoCmd.OpenForm "frmEmployData", acNormal, , strWHERE
DoCmd.OpenForm "frmEmployAtt", acNormal, , strWHERE