I'm having problems with requerying forms, I have a form that opens up a few pop-up forms that change info. the pop-up forms have code to requery the main form when they close. It normally works fine but sometimes it does not work at all and it's driving me nuts.
I looked up the help with regards to the Onactivate event but it states that it will not work if the form receives focus from a pop up form which is what I'm doing.
The code I'm using is very simple:
(it's placed in the onclose event of the pop up form)
the database is split front/backend it appears that when I modify the backend database it sometimes causes the requery not to function properly. I always refresh the table links and compact and repair the frontend database after any modifications.
It's still driving me mad, am I missing out something simple?