Refresh All

[QB]

In access 2007, what is the equivalent code to the Refresh All button found
on the Home tab of the ribbon?

I tried Me.Form.Requery but it does not do the same thing.

QB

 

[June7 via AccessMonster.com]

If you want to requery the form's underlying dataset then Me.Requery should
do it.
Me.Refresh will reflect changes to the records of the underlying dataset but
should not requery so if record was added it would not show. Might have to
use them in sequence. I have had need to and seems to do what I want.

 

[Proposal Doctor]

I too have been fighting with this problem for a couple days and what seems
to work in Access 2007 macros is RunCommand | Refresh. This seems to be
the statement behind the Refresh All button on the interface.

The problem that I am still having is replacing existing Close Form buttons
with ones that use the RunCommand statement. For some reason, Access doesn't
always lets me out of the IDE.

You may sometimes need to use a couple RunCommand | Refresh, sandwich them
around other statements in your macro.

QB, I wish that the Refresh All statement worked automatically in Access.
Placing it on a form as an OnClick command is an extra step that I don't want
to do.

HTH

David