Copy Button

[John Steven]

Hi All,

I'm new to this forum, so bear with me.

I have a form that has a control button on it to "Print Requisition". When the button is pressed, it calls on a parameter Query for the "PO Number". After typing in the requested "PO Number" and pressing OK, a Report is generated. Does anyone know of a simpler way to do this???

Thanks in advance

Later
John Steven

 

[Fizzio]

Rather than pushing a button then typing in the PO number, why not use a combo box / Listbox to select the PO number and feed that value into the query suppling the report. You can keep the button to print the report if you like but an alternative would be to run the report from the After_Update event of the combo.

Eg in query, rather than having [Please Enter PO Number] replace it with
[Forms]![NameofForm]![NameOfCombo] where you replace the name of the form and the name of the combo in the expression. This assumes that the PO number is the 1st column in the combo box.

HTH

 

[John Steven]

Thank for the Response Fizzio,

I'll give that a try and post back to let you know the results.

Later
John Steven