Running a requery

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

Guest

Hello all,

I'm a novice with macros (and access in general) and would like to know how
to get the Requery macro running.

I have a bunch of reports that are based on queries. I would like the
reports, when opened, to re-run the query that they are based on.

The information box in the Marco builder makes it sound like the requery is
the option that I need. So I've tried this. But (and there's always a but) it
asks for a "Control Name". I've entered what I think is the control name, but
to no luck.

Can anyone help me with this?

Thanks in advance.

Tim
(The uni subject spent on Access seems so long ago now!)
 
When you open a report, the report runs its RecordSource query
automatically. The same is true when you open a form. You do not need to run
the query first, then open the report, if that is what you were thinking?
 
Thanks Ken.

I was thinking that the Query would have to run each time to update the
report and was looking for a way to do it without having to open and run the
query again.

Thanks for you help. You've put my mind at ease.
 
Back
Top