Moving From Form to Report

[herbc0704]

I have created a continous form that list Purchase Orders and Dates to be received.

I have also created a report based on a separate query that the user is prompted for the purchase order number. The report show details of items on the purchase order.

Is there a way to create an event that would allow the user to double click the Purchase Order Number in the form, and the report to run.



I vaguely remember reading something about this before but can't get searches to this.

Thanks
Herb

[pbaldy]

How about this technique, with OpenReport:

BaldyWeb wherecondition

[herbc0704]

Baldy,

Thanks I remember now it was from you where I read it. Thanks for the refresher again.

[pbaldy]

No problemo.