How do I create a report for a specific user input in access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Create report based on user input - 21 Dec 2005 14:35 GMT

I am trying to create a report based on user input. I ask user to enter the
product number and base on that number a report will be generated pulling
other data in that matches the specific record. For example, I enter product#
20 and that record has other information such as description, quantity
available, etc. The report will show the description, quantity available and
product# for the product# 20 only. I am not sure how to generate this report.
Please help.

Karina

Reply to this Message

Klatuu - 21 Dec 2005 15:35 GMT

Use the Where Condition arguement of the OpenReport method.

> I am trying to create a report based on user input. I ask user to enter the
> product number and base on that number a report will be generated pulling
[quoted text clipped - 5 lines]
>
> Karina

Reply to this Message