Dual conditions for Macro

[kman]

I have created a macro that successfull produced a report based on a macro that uses a form field for a where clause in a report.

Now I want to add another condition but it is giving an error. Can you pass two conditions in a single macro in a single where clause.

This where clause in my macro worked:
installation is the fields
form is customer labels dialog
and field name on form is select country
[Installation]=[Forms]![Customer Labels Dialog]![SelectCountry]

When adding another clause this does not
[Installation]=[Forms]![Customer Labels Dialog]![SelectCountry] and [Compo]=[Forms]![Customer Labels Dialog]![SelectCompo]

 

[Russell Hauf]

Can you post the entire code and/or SQL? A little more info is needed.

Thank you,

Russell

 

[Russell Hauf]

Also, what is the error?