Wire up button to run report based on parameter query

  • Thread starter Thread starter Paxton
  • Start date Start date
P

Paxton

I have a report (rptInvoice) that is based on a parameter query. The
parameter value is a month (January 2005, February 2005 etc). I have
created a form with a combo box pre-populated with the month options.
I have wired a button on the form up to open the report.

I guess I need to write some code to capture and pass the value of the
selected option in the combo box as an argument to a sub in order to
prevent the parameter dialogue box from appearing, and to open the
invoices for the selected month, but I'm not sure how to do this.

Any help would be appreciated. Can anyone point me to an appropriate
tutorial for this kind of thing?

Paxton
 
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

Query Parameter using multiple options 0
Report Query Parameters 2
Parameter Value error in a Subform 0
how to pass a parameter to a query base of a query that is the base of a report 0
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
Enter Parameter Box pops up even though its not in query 7
Parameter Query 2
report after parameter form 3

Back
Top