One More Report Filtering Question

cgdrake

Registered User.
Local time
Today, 12:14
Joined
Jul 22, 2007
Messages
38
OK, so I added another filter to the reporting sub:

DoCmd.OpenReport ("AllSamplesReport"), acViewPreview, , "[pvmt_analysis_section_id] = " & Me.cboSectionNo " and [pvmt_sample_nmbr] = " & Me.cboSampleNo


pvmt_analysis_section_id and pvmt_sample_nmbr are integers.

I keep getting syntax errors. What is the proper syntax for this?

Thanks for any help.
 

Users who are viewing this thread

Back
Top Bottom