Refreshing a report from Switchboard

[barry@tecelectric.com]

I am using Access 2007. I have created a simple switchboard that has
an item that runs a report that is based upon a query. This query
asks for a range of job numbers. When first going in to the
switchboard, it asks me for my range and everything is great.
However, if going back to run it again, it justs repeats my last
query. I know you could hit F5 to refresh but I'm trying to make this
simple for the user. Can anyone tell me what to change so that every
time I hit the button for the report, it asks me for my criteria each
time? TIA!
Barry

[fredg]

Re: Refreshing a report from Switchboard

On Sat, 30 Jun 2007 09:52:49 -0700, barry@tecelectr ic.com wrote:

I am using Access 2007. I have created a simple switchboard that has
an item that runs a report that is based upon a query. This query
asks for a range of job numbers. When first going in to the
switchboard, it asks me for my range and everything is great.
However, if going back to run it again, it justs repeats my last
query. I know you could hit F5 to refresh but I'm trying to make this
simple for the user. Can anyone tell me what to change so that every
time I hit the button for the report, it asks me for my criteria each
time? TIA!
Barry

If Access 2007 is like the previous versions of Access in this
regards, you cannot just refresh the report.
You need to first close the report, then open it again.

If CurrentProject. AllReports("Rep ortName").IsLoa ded Then
DoCmd.Close acReport, "ReportName "
End If
DoCmd.OpenRepor t "ReportName ", acViewPreview



--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail