View Full Version : How to Report Current Record Only?


Jason1971
05-24-2010, 04:45 PM
My report is reporting all records :mad: I just want to report the current record. Is there a setting in the report properties to only report the current record?
Thanks.
Jason.

boblarson
05-24-2010, 04:52 PM
Do you mean from an open form?

Jason1971
05-24-2010, 06:04 PM
Do you mean from an open form?

Yes, thanks.

PNGBill
05-24-2010, 07:52 PM
If the report is run from a query of all records then put this (edit first) in the Criteria of the link field for your query.

[Forms]![YourFormName]![YourFieldName]

This will tell the query to match the field you entered the criteria in to the field in the form you refer to which presumably is open.