I have a form linked to a query. The query is looking at a table and works just fine.
The form seems very slow to show updated data on the query. Is there a way of forcing the query to run from the form on open?
Yes, the form is bound to the query.
Sometimes the data is there immediately after an udate sometimes it takes a while, maybe 15 minutes.
Seems pretty odd to me. The query is run when the form is opened, if the updated data is not there I obviously check the query itself which shows the data.
Don't know what is going on!