problem with syntax error message, says its missing operator help

G

Guest

I have just started setting up a database and I have a command button on data
entry form. When I tried to set up the expression for it all seems fine but I
get an error message when I try to run. It says there is a syntax error
(missing operator) in query expression 'Data Concerning Program
Changes.[ID].' I can not figure out what I am doing wrong. I am not sure what
the missing operator is in this expression. Can anyone help.
 
E

Eric D via AccessMonster.com

Try enclosing your field in brackets
[Data Concerning Program Changes].[ID]

If that doesn't work, you need to provide a copy of the query. Open the query
in design mode, find the View icon on the Tool Bar... under File and click on
the down arrow. Select SQL View. You should now see the SQL version of your
query. Copy it and Paste it into your question here.
I have just started setting up a database and I have a command button on data
entry form. When I tried to set up the expression for it all seems fine but I
get an error message when I try to run. It says there is a syntax error
(missing operator) in query expression 'Data Concerning Program
Changes.[ID].' I can not figure out what I am doing wrong. I am not sure what
the missing operator is in this expression. Can anyone help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top