In the meantime I set up a global module with global Boolean 'flag' variables that I turn on and off depending on whether the form is open or not. And then use these variables on the other forms to test if the form is open.
flagFormAOpen = True
flagFormAOpen = False
It works. But may give the suggested functions a go. Less messy code, and less commenting.
I was attempting to use Form 'Got Focus' for the Requery but did not work... I've never used 'On Activate' before... Yay! Now I know what it does and that's what I was originally trying to fix the prob with.
Thanks for the 'If form is open' test code, also... I'm sure I'll need that at some stage anyway.
I think I'll revise my VB texts and study up on my form "Event Properties".