Two WHERE conditions in OpenReport

[mcmcd99]

Hello, I have a button set up to open a report by date. I would like to add a second condition to open it by type as well, so I can have the report show only [Enter Type] type entries on a specific date.



Here is what I have in the macro editor:

OpenReport

Where Condition: [Reports]![rpt_date]![tsdate]=[Enter Date: MM/DD/YY] And [Reports]![rpt_date]![type]=[Enter Type]

It lets me put in the entries, but doesn't show me the results.

[June7]

I would not use popup input parameters - can't validate user input. Use controls on a form for user input and reference those as parameters.


Where Condition: [tsdate]=[Enter Date: MM/DD/YY] And [type]=[Enter Type]