Solved

Spot Syntax error with DoCmd.OpenForm

Posted on 2014-03-18
2
323 Views
Last Modified: 2014-03-18
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
Comment
Question by:Fritz Paul
2 Comments
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
Hi,

Is  Del_N_ID empty ?

Regards
0
 

Author Closing Comment

by:Fritz Paul
Comment Utility
Yes! It was empty.
Clever you!
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now