On Open for Event Procedure in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I write an event procedure to do this:

On Open
I want it to show only Current User's Records?

Thanks

Debbie
 
Debbie,

I am assuming a fair bit here. Some more detail inyour query would help
others provide an appropriate response.

I assume you are calling your report from a form which is displaying the
desired customer. On your form I would place the customer ID field (if it is
not already there). You can set the visible property to false if you don't
want to display it.
In the query for your report set the criteria under the customer ID
=[forms]![your form name].[customerID]. Change the names of the "your form
name" and "customerID" to reflect the names in your situation.

This will limit the records to only those that match the currently displayed
customer. The reason for using the ID field and not the customer name is that
you may have multiple "Ms Smith"s and the resultant report will be inaccurate.

The form with the customer details on it will need to be OPEN for the report
to run correctly.

If I have misunderstood please repond with as much detail as you can.

HTH

Terry
 
Back
Top