Stephen Parker:
Yes.
Yes? Is that a
yes to my question "
Is it because the processes in FileB are running asynchronously?"? I'll have to assume so although frankly, that is not a clear way to communicate.
Stephen Parker:
It sounds so strange for Microsoft to make the Access modules code/functions available via a Reference but not the modules code/functions behind the forms as these are also modules
Hold your horses. Who told you that was the case? And why do you bring it up here? It's irrelevant as you don't even have a reference to that database (at least that you've shared so far), even to access standard code modules.
Let's take a step back. Form and other object-based modules are accessible, just as the standard code modules are, you just need to know how and to understand that forms are a class, not the instance of the class as we are used to treating them as. If you want to know how to access the public methods of a form class then look at the class name in the VBA IDE that is shown for each module-enable class. Typically forms have their generally known name (EG. frmMain) with Form_ at the start, so Form_frmMain. Form methods may be accessed this way. To access a form method, or any code, of a database you have no access to though, is a whole different ball game.
A potential solution would be to try passing the calling form itself, as an Form object, to the called routine in the other database (
FileB) as a parameter. That way, it may be possible to call a
.Requery of the passed form object reference directly the process has completed.