Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

Spot Syntax error with DoCmd.OpenForm

Please spot the syntax error in this line, which causes the error message below.

DoCmd.OpenForm "frmtblTransactions", acNormal, , "DelNote = " & Del_N_ID, , acNormal

Syntax error (missing operator) in query expression 'DelNote = '.

DelNote is a field in the source of frmtblTransactions and Del_N_ID is a field in the source of the present record of the form from which the frmtblTransactions is opened.
0
Fritz Paul
Asked:
Fritz Paul
1 Solution
 
Rgonzo1971Commented:
Hi,

Is  Del_N_ID empty ?

Regards
0
 
Fritz PaulAuthor Commented:
Yes! It was empty.
Clever you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now