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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make scroll bar permanently visible, Word 365 0
Bugs in Office 2019 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Auto match destination formatting for Mac 0
a 'Refresh'ing question 2
refresh subform control 1
refresh/requery subform 2
Set focus 4

Top