Access Parameter Queries

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hi,

I have designed dialog boxes which allow the user to enter a specific
critera for data they are searching for only problem is that when the
user clicks on the OK button it opens up the query how can I change it
so that the results from the selected criteria are displayed in a
report??

Fie
 
Hi

Base the report on a query that has a criteria prompt in it. You will be
prompted before the rport opens.
Open the report with a button - you could use something like this behind the
OnClick action.

Private Sub ButtonName_Click()
DoCmd.OpenReport "ReportName", acViewNormal, "", "", acNormal
End Sub

Hope this helps
 
Fie,
It sounds like you have created a form on which the user enters the
specific criteria and that you have already created a query which uses
the data entered on the form as its source. If so, all you need to do
now is create a report based on the QUERY and then put a button on your
form to open the REPORT. If you need more help, please post back.
Darrell
 
Back
Top