Syntax Help

[FranD]

I need to identify criteria for a report dialog box. There are three fields in the criteria (dept, section and billing area) and I can't seem to get the syntax right. Here's what I have:

strWhereCriteria = "Div_Name = """ & Forms![frmReportDialog]!cboDept _
& """ and Section = """ & Forms![frmReportDialog]!cboSection _
& """ and BillingArea = """ & Forms![frmReportDialog]!cboBArea & """"

 

[Jack Cowley]

If all of the criteria are Text fields then try this:

strWhereCriteria = "Div_Name = '" & Forms![frmReportDialog]!cboDept _
& "'" and Section = '" & Forms![frmReportDialog]!cboSection _
& "'" and BillingArea = '" & Forms![frmReportDialog]!cboBArea & "'""

Hope I got it right!