open report based on data on form

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

Guest

Is it possible to have Access open a report based on the value in a field on
an open form? Based on the Procedure Number that is on the form I would like
to be able to open the report that applies. Or is there another way to
handle this?
 
Sure. A few different ways in fact. My favorite is to build a query that
references the form in the criteria. For example the criteria for the
Procedure Number field would look like:

[Forms]![YourFormNane]![Procedure Number]

Next build your report based on this query. Then create a button on the form
that opens the report.
 
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

Parameter Value error in a Subform 0
Access Access Report Works on One Machine but not Another 3
Form and Report Calculations slow 1
How to apply the form filter on the report? 3
Access Open Form with WhereCondition 6
how to pass a parameter to a query base of a query that is the base of a report 0
underlying query for report 1
Change lblHeading.Caption of report based on which form's buttonclicked 5

Back
Top