Syntax error (missing operator) in query expression (1 Viewer)

Jambuck

New member
Local time
Today, 07:04
Joined
Dec 4, 2012
Messages
3
Hi.

I have recently been recieving an error message:

"syntax error (missing operator) in query expression 'field name' "

This happens each time I try and right click any of the fields on a certain page of my database whilst in datasheet view.

Can anyone help me fix this problem or offer some advice.

Thanks,
 

pr2-eugin

Super Moderator
Local time
Today, 07:04
Joined
Nov 30, 2011
Messages
8,494
Hello.. Welcome to AWF.. :)

See if there is any event associated with the Form_OnClick() event. Or the controls that causes the error..

Also the Syntax error normally points to the query that forms the Record Source of the Form.. If you have accidentally compared Text with Number or vice-verse..
 
Last edited:

Jambuck

New member
Local time
Today, 07:04
Joined
Dec 4, 2012
Messages
3
Thanks for getting back to me so quickly.

My problem is also that I don't know how to do any of the checks or fixes that you mentioned. I didn't design the database myself and until now have only input data, so have very little knowledge of Access and how to get around.
 

pr2-eugin

Super Moderator
Local time
Today, 07:04
Joined
Nov 30, 2011
Messages
8,494
Check the image for how to check the Form properties..

 

Attachments

  • formProp.png
    formProp.png
    35.8 KB · Views: 16,327

Users who are viewing this thread

Top Bottom