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.
 
Thank you, thank you, thank you!

Ember

Al Camp said:
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.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering a form based on the values of a subform 0
Sort by problem 6
Specifying conditional Criteria in a Query or Report 6
Running a report for a specific record from a form 6
filtering a form based on a filter on an open form 2
Access Access Report Works on One Machine but not Another 3
Access Form - Lock Fields from Editing 0
How do I use a form to run a query? How do I bind the query to it 2

Back
Top