Refreshing form that doesn't have the focus

J

Joan

How does one refresh a form or it's underlying record source in VBA when it
is not open or does not have the focus?

Joan
 
K

Kelvin

You can refresh the form with Forms!NameOfForm.Refresh. You cannot refresh
a form if it isn't open. The data from a form cannot be accessed if the
form isn't open so there is nothing to refresh.

Kelvin
 
J

Joan

Kelvin,
Thanks for the info. I tried a different approach by using an update query.
Thanks again for you reply.
Joan
 
Top