Error 3075: missing operator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I keep getting the above error on this code

DoCmd.OpenForm "frmDealerLog", , , "IDLog = " & IDLog
 
sorry
the full error is syntax error (missing operator)

DoCmd.OpenForm "frmDealerLog", , , "IDLog =" & IDLog
 
Does IDLog have a value when you try to use it? What is it?
 
Infected04 said:
I keep getting the above error on this code

DoCmd.OpenForm "frmDealerLog", , , "IDLog = " & IDLog
Click to expand...


That seems to imply that there's something funky about the
value of IDLog. What kind of field is it, text, numeric or
date?

If it's text, then you should use:

"IDLog = """ & IDLog & """"

or an equivalent.
 
You must log in or register to reply here.

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

Similar Threads

Syntax error (missing operator) 4
Error 3075 2
runtime error 3075 2
Run-time error '3075': Extra ) in query expression... 4
Error 3075 Syntax Error 5
3075: Syntax error (missing operator) in query expression 2
Error 3075 When Appending Form Data to Table 2
repeating date of previous record 5

Back
Top