ACK! Simple Report Problem

[SShefer]

I have a report. I have my data, but when I view the report I can see everything. How can I narrow it down to one criteria.

EX. Customers. View report and see them all. I just want to see one.

How do I do it?

Thanks!

 

[genomon]

Use DAO to create a temporary recordset in VBA. Do a .MoveFirst. Set the control or section recordsource property (in code) to the first record:

rstRecordSet.MoveFirst
TextBox.Text = rst.FieldName

 

[donnadee]

Is there a query for the report?

You could go into the report properties and use the query to look up the report for just one customer.

You would enter the name of the customer in the customer field and run the report.

Just remember if you save it, you'll need to change the query back or the report will be incorrect for the next use.