Report - Input Values

[eveCalypso]

Hello All,

Is there a good way of allowing users to input paramters to a report?
I would like my user to select a Stock Item up front, the report will then give a load of details about this item, including recent transactions.

How is it done?
Any help would be appreciated!

Regards,
EvE

 

[chloec]

If the user selects the item on a form then clicks a button to open a report there is no reason why you can't use the where condition of the docmd.openreport function.

 

[eveCalypso]

Hello chloec,

I did come to the conclusion that for any usable input values, I would have to have a FORM.
I wondered if there was a way to bypass the form.
Clearly not ;-)

Thank you for your help
Regards,

EvE