Re: How to for a report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In the query, in design view, under the field that has the value you wish to
select on, add something like the following into the "Criteria"
section/cell:

Forms!YourFormName!cboYourComboBoxName

You could also use the builder/wizard to actually pick this, removing the
risk of BFF (big fat fingers, like mine!).

Regards

Jeff Boyce
Microsoft Office/Access MVP


"frustratedwthis" <frustratedwthis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:61EE273E-182A-4766-8F18-AF704591D77E@xxxxxxxxxxxxxxxx
I think I understand...lol
I am just not sure how to get the query to look for the combo box on the
form....
Thanks for the quick response :)

"Jeff Boyce" wrote:

You could create a form with a combo box on it. The combo box would be
based on a query that finds account numbers. You would add a command
button
to open the report.

Then you'd base your report on another query, one that "looks" to the
form's
combo box for the selection criterion for the account number field.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"frustratedwthis" <frustratedwthis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:C98257C6-55D0-434A-BA9F-35D38E37B42A@xxxxxxxxxxxxxxxx
I have 3 tables and many forms in my database. I would like to have a
report
that you can put in a certain account #, vendor ID, etc. and print a
report
just for that criteria. I can build a report that shows ALL the
information
in the database, but I would like to be able to do it for one vendor or
one
account number. Can this be done?
Thanks in advance





.

Quantcast