Spot Syntax error with DoCmd.OpenForm
Posted on 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.