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

 

[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

 

[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