Currently when a form query is run, it not only takes a long time, but also doesn't provide any feedback regarding when it's still running or completed.

A lot of the time it looks like it's finished, but when the user tries to click on a field access then updates a few more fields.

This is a monster database that has no place on MS Access, and will eventually be moved to a DB server. But in the meantime (possibly 6months) it needs to be used.

So the question is; are there any events that can be hooked into with VBA to improve the feedback experience?

For example, indicating that the query is still being run, indicating when it's completely finished, and not showing partial records until it is finished. Instead of the "not responding" hell we currently see.

I've just spent a few hours Googling same and looking through the events lists for forms and queries with no result, so any pointers are appreciated.