How to Report Current Record Only?

Jason1971

Registered User.
Local time
Today, 20:27
Joined
Jan 19, 2009
Messages
46
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom