Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Spot Syntax error with DoCmd.OpenForm

Posted on 2014-03-18
2
Medium Priority
?
335 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 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 39936256
Hi,

Is  Del_N_ID empty ?

Regards
0
 

Author Closing Comment

by:Fritz Paul
ID: 39936260
Yes! It was empty.
Clever you!
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

572 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