Open a report based on criteria from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top