<div>
Yes! It was empty.<br />
Clever you!
</div>


<div>
<div class="content wysiwyg-content">
Please spot the syntax error in this line, which causes the error message below.<br />
<br />
DoCmd.OpenForm &quot;frmtblTransactions&quot;, acNormal, , &quot;DelNote = &quot;&nbsp;&amp; Del_N_ID, , acNormal<br />
<br />
Syntax error (missing operator) in query expression 'DelNote = '.<br />
<br />
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.
</div>
</div>


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.

Spot Syntax error with DoCmd.OpenForm

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.