There are many ways. One of the simplest is to use a query as the recordsource of the document. Then in the criteria section of the query under the order number put this [Please enter an order number]
You must include the brackets. This will prompt the user and then filter your report. Hope this helps. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: Daemon <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, April 18, 2007 5:03:15 PM Subject: [ms_access] Reports I am trying to creat a report that pulls information based on input from the user. I want them to be prompted to enter a purchase order number that have a report generated that show all data from a table for that PO number. I know this should be smiple but I'm just not getting it. Help! __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
