How can I get a report in Access using record displayed in a form

  • Thread starter Thread starter maxoo
  • Start date Start date
M

maxoo

I already have a report that shows all the records in my db; but, what about
if I need to show and print a particular record using the same form that I am
using to open and print the report for all the records?
 
Add a textbox to enter criteria.
In the query for the report use the textbox as criteria like this ---
Like [Forms]![YourFormName]![TextBoxName] & "*"

If you do not enter anything it will return all records.
 
Back
Top