Wire up button to run report based on parameter query

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
 
Top