Recent content by duffy

I have a number of Reports in a db that call parameter based queries to supply the data. The parameter queries receive the required parameter from a form field. Normally the reports are run from a Command Button on the form that is open. Now I want to also be able to run the Reports through...

I have a number of Reports in a db that call parameter based queries to supply the data. The parameter queries receive the required parameter from a form field. Normally the reports are run from a Command Button on the form that is open. Now I want to also be able to run the Reports through...

How would you write a procedure to use the same user input parameter data to run two consecturive queries?

It worked like a charm! Thank you.

I have a form for entering Purchase Orders that is comprised of a main form with PO Header info and a subform where the line item detail of the PO is entered. The main form and subform are linked by the PO# field being the Link Master & the Link Child. The data from the main form goes to one...