Help with error message

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

I'm looking for suggestions on how to deal with a error message.

Microsoft Access
Syntax error in query expression
'First([DateSerial([DateSerial([Forms]]![frmSlaimSummary]![[cboYear],1,1)])'.

I just started getting the error message when I run "frmClaimSummary" .
The form is designed to be a user interface to print a report
"rptClaimSummary"
The form has two combo boxes on it cboYear and cboMonth that are used to
pass date information to one of the underlying queries that feeds the
report.
cboYear has a single column and cboMonth has two columns.
Some kind of box flashes on the screen just prior to this error message
.... to fast to tell anything about it.

I recognize
"([DateSerial([DateSerial([Forms]]![frmSlaimSummary]![[cboYear],1,1)])"
as a portion of the date expression in the 'Where' Between expression
for the query ... I don't recognize the word "First" as being anywhere
in my code?

Any suggestions as to how to track this problem?

Bob
 
Bob,

You appear to have a double-up of the DateSerial function, which
doesn't make sense, plus a few rogue [s and ]s. Shouldn't it be...
First(DateSerial([Forms]![frmClaimSummary]![cboYear],1,1))

- Steve Schapel, Microsoft Access MVP
 
Back
Top