Error 3075: missing operator

[Guest]

I keep getting the above error on this code

DoCmd.OpenForm "frmDealerLog", , , "IDLog = " & IDLog

 

[Guest]

sorry
the full error is syntax error (missing operator)

DoCmd.OpenForm "frmDealerLog", , , "IDLog =" & IDLog

 

[Douglas J. Steele]

Does IDLog have a value when you try to use it? What is it?

 

[Marshall Barton]

I keep getting the above error on this code

DoCmd.OpenForm "frmDealerLog", , , "IDLog = " & IDLog

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.