View Full Version : Report error after data edit


12588sam
10-01-2010, 02:54 AM
Hi everyone,

I'm new to the forum so I hope this is in the right place.

I have a report that I'm having some problems with. The report is part of an issues tracking database.

The report shows all open issues assigned to a particular user. The user is selected from a drop down list in a form (Assignee_Form), which onclick runs a query (taking the value from the drop down list) and then subsequently the report. This works fine.

The report then contains links on issue title which brings up an issue edit form. When a user edits an issue and closes the issue edit form the report doesn't refresh automatically. Essentially it behaves as if I have just ran the report without the query, so it doesn't know which user I want issues displayed for. Is there anyway I can tell the report to open with the last selected User in the Assignee form?

vbaInet
10-01-2010, 12:14 PM
Use Reports!NameOfReport.Requery on the Unload event of the edit form or close and open the report.