Access On Click event not working on form

[bmanning20]

Access On Click event not working on form. Access cannot find the field '1' referred in your expression


Private Sub btnPreview_Click()
DoCmd.SetWarnings False
cboFullName.SetFocus
DoCmd.OpenQuery ([Open Projects Employee])
DoCmd.OpenForm ("[Open Projects].[Owner]"), acViewPreview
DoCmd.SetWarnings True
End Sub

Private Sub cboEmployeeName_Click()
Dim myName As String
myName = "Select * from Projects where ([Owner]=" & Me.cboEmployeeName & ")"
Me.[Project List].Form.RecordSource = myName
Me.[Project List].Form.Requery
End Sub

[pbaldy]

Which one? If I had to guess:

myName = "Select * from Projects where [Owner]=" & Chr(34) & Me.cboEmployeeName & Chr(34)

[ssanfu]

Welcome the the forum....


Not a lot of info to go on.....

Which click event has the error?


Looking at the btnPreview code, I see two errors immediately.
1)

DoCmd.OpenQuery ([Open Projects Employee])

This is improper syntax. The query name should be a string.
Example:

DoCmd.OpenQuery "OpenProjectsEmployee"

Also, you should not use spaces in object names.... (I removed them in the example)

2)
The second error is

DoCmd.OpenForm ("[Open Projects].[Owner]"), acViewPreview

I doubt that you have a form named "[Open Projects].[Owner]".
Again, the form name should be a string, like the form names in the Navigation Pane.