I have a function I've made to refresh a local table from a sharepoint list if the data was updated more than 4 hours prior to the function running. It works as expected. However, the query this function runs can take a long time (5+ minutes outside of the network) to complete. I'd like to have a means of, once the function triggers the query, to wait for it to complete and then let the user know it is done (via a MsgBox()).
Is there anyway to wait for a DoCMD.OpenQuery() to complete? Any other ideas?