Specifying recordset thru ACCESS VBA to print report 1

[bcken]

I have a report that uses a query as it's recordsource. The query contains a parametrical prompt for a value based on the AREA field. I then have to run a make table query that corresponds to the report just generated. I then copy the table just created into an another table with a name that contains the AREA value. I also have to create a pdf file of the report.

I am able to create all these components individually, but when I combine them in a module, I am prompted for the AREA value several times.

I would like to be able to specify the AREA value one time to create the report, again for the make table query and then again use it for the rename command

Any help is appreciated

 

[KenReay]

Hi

Presumably you have the parameter simply as [Enter Area] or something similar in the criteria of the query(s)?

Set up a form, put a combobox or text box on to allow user to enter the area code (say this is called frmMyForm and cboArea), have a button on the form which runs the reports etc,

as longas the form is open you can address the area with the syntax Forms!frmMyForm!cboArea, change all references to [Enter Area] (or whatever) to Forms!frmMyForm!cboArea Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK