DoCmd.OpenReport with 2 and + criterias...

[jondion80]

Hi everybody!
Why does this line is ok
DoCmd.OpenReport "test1", acViewPreview, , "[C07-CODE]=forms!Formulaire1!criter_code.value"

And that this line makes a report with no data?

DoCmd.OpenReport "test1", acViewPreview, , "[C07-CODE]=forms!Form2!criter_code.value" AND [C16-VEND]=forms!Form2!criter_vend.value"

It seems that it's hard to put more than one criteria at the same time. Thanks for your help!

 

[oharab]

You've got an extra quote mark. Try this:

DoCmd.OpenReport "test1", acViewPreview, , "[C07-CODE]=forms!Form2!criter_code.value AND [C16-VEND]=forms!Form2!criter_vend.value"

Another thing you need to check are the field types. This is ok if [C16-VEND] and [C07-CODE] are both numbers, but will fail if they are text values.

Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.pnn.police.uk
----------------------------------

 

[jondion80]

Thanks Ben,
Well the extra quote was a copy/paste error
About the two fields, both are text values. What's wrong with this and how can I can expect to solve my problem? Thanks again.

 

[oharab]

Personally I would concatenate the form values into the statement so:

DoCmd.OpenReport "test1", acViewPreview, , "[C07-CODE]='" & forms!Form2!criter_code.value & "' AND [C16-VEND]='" & forms!Form2!criter_vend.value & "'"

HTH


Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.pnn.police.uk
----------------------------------