syntax docmd.openreport with more criterea

P

Peter

Hello everyone,

My problem is propably just a syntax problem.

Either of these statements do the job:
DoCmd.OpenReport "R00_t01_Opdrachten", acViewPreview, , "ObjectNr = " &
Me.ObjectNr DoCmd.OpenReport "R00_t01_Opdrachten", acViewPreview, ,
"VolgnrInt = " & Me.VolgnrInt

But this one doesn't:
DoCmd.OpenReport "R00_t01_Opdrachten", acViewPreview, , "ObjectNr = " &
Me.ObjectNr And "VolgnrInt = " & Me.VolgnrInt

Can anyone help?
Greetings,
Peter
 
D

Douglas J. Steele

Yup, it's syntax. <g>

DoCmd.OpenReport "R00_t01_Opdrachten", acViewPreview, , _
"ObjectNr = " & Me.ObjectNr & " And VolgnrInt = " & Me.VolgnrInt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting a Report to Excel 2
Limiting Criteria to Exact String (not contain) 7
Creating report on criteria 2
Selection Form confilicts with on no Data 4
Print All/Selected 0
Setting the "number of copies" in code for an access report 2
Print to PDF in VBA Code 11
Run time error '424' Object required 0

Top