Run time error 2465 - can't find the field '1' referred to in your expression

[moneypennie21]

I am trying to create a click button event to open a form based on a parameter but keep getting this error Run-Time error '2465' Microsoft access can't find the field '|1' referred to in your expression. the code I'm using is



Private Sub Command2_Click()


DoCmd.OpenForm [Visit Data], , , "[Branch code] = '" & Me.Combo0 & "'"




End Sub



Visit data is the form - it contains the space in the name (someone else created this database not me) and Branch code is a text field which also has the space in the name of the field

Any ideas?

Thanks

J

[moke123]

The form name needs to be in quotes.

DoCmd.OpenForm "[Visit Data]", , , "[Branch code] = '" & Me.Combo0 & "'"

[moneypennie21]

I did try this but then I got a different error saying the form name was misspelled or did not exist however I have realised as this is a simple database I have renamed the form to visit_data - removed the [] and it works now. thanks

J

[moke123]

I should have realized that the brackets were not needed in the form name but the quotes were. I never have spaces in names but you'll see many postings on the forum about them.