Open a report based on criteria from a form

E

Ember

I have a "Main" form that has combo boxes which I would like to connect to a
report through a query, however, if nothing is selected I would like the
default to return all records.

How do I create this default?
 
A

Al Camp

Ember
Use the Like operator. Say you were filtering by State in your report
query...

State
Like Forms!frmYourFormName!cboYourComboName & "*"

If cboState is Null, all States will be reported.
 
Top