Correct Query to generate a form

[George]

I have a button on a form such that when pressed it is to open another form by a query. The query I am using is:

Private Sub Command17_Click()
DoCmd.OpenForm "Edit Signin", acNormal, , "OfficerName = " & WorkersName
End Sub



OfficerName is a field in the "Edit Siginin" Form, and WorkersName is a global Variable.



My error message is : Syntax error ( Missing Operator ) in query expression 'OfficerName = Hector Belle'

Can anyone assist

[davegri]

DoCmd.OpenForm "Edit Signin", acNormal, , "OfficerName = '" & WorkersName & "'"

Add red edit. String variables need to be enclosed in single quotes.

[George]

Thanks Davegri. It's working fine.

[George]

However if I add a little more I have an error message "Mismatched data type:

Private Sub Command17_Click()
DoCmd.OpenForm "Edit Signin", acNormal, , "OfficerName = '" & WorkersName & "'" And "Datevalue(DateCreated) =# " & Date & "#"
End Sub


Can you also advise on this problem?

[orange]

Try
DoCmd.OpenForm "Edit Signin", acNormal, , "OfficerName = '" & WorkersName & "' And Datevalue(DateCreated) =# " & Date & "#"

[George]

Thanks. It is working fine. But as you can see I almost made it. Thanks to these forums I am coming of age.