J Joan Dec 16, 2003 #1 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
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 Dec 16, 2003 #2 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
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 Dec 17, 2003 #3 Kelvin, Thanks for the info. I tried a different approach by using an update query. Thanks again for you reply. Joan
Kelvin, Thanks for the info. I tried a different approach by using an update query. Thanks again for you reply. Joan
