Running a requery

[timmycav]

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!)

 

[Ken Snell \(MVP\)]

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?

 

[timmycav]

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.