Is pausing VBA code in one form possible?

[twgonder]

I have two forms, A and B


A is a form for entering a record, let's say customers
B is a form for searching for records on which A is based and can return an ID for a customer

I'm not even sure this is possible:
I need the procedure in A that calls B to stop and wait for a value to be calculated and returned from form B (via a global variable)
When B closes, A can get the variable and continue with what it needs to do.

I've searched, and some suggest making B modal, but that doesn't work,
the procedure in A continues on its merry way as formb B opens.
Others suggest using an on error goto, but this situation doesn't have an error to trap.

I guess I could do a loop in A until a condition is met, but I'm thinking there must be a more elegant way without running looping code.
(I'm not sure this would work either, as then I need a "release" from the running code in form A to let Form B do its thing)

Can there be a "conditional pause" in VBA in form A until form B closes?

[Minty]

Opening the form in Dialog mode will achieve the result you require

Code
More Code
DoCmd.OpenForm "YourFormB", , , , acFormEdit, acDialog, sMyOpenArgs
ThisCodeHere won't run until YourFormB is closed

[twgonder]

@ Minty Cool and thanks for the quick reply. I'll give it a test and dig deeper into all the options of DoCmd.OpenForm (I proabbly read it before but it didn't register as for the purpose of acDialog).
I am opening instances of the form, so it gets tricky, so I'll have to see its impact on other form A that can be open.

[Minty]

From memory if any form is opened as a dialog nothing else (In Access) can receive the focus or operate, similar to a error message or msgbox.

[moke123]

Here's a write up from DBG re: Modal vs. Dialog

http://thedbguy.blogspot.com/2016/02...log-forms.html

[twgonder]

I've tested the acDialog method, and it seems to work.
The problem I'm running into is that the form is then modal and popup as best as I can tell. And popup isn't a property that can be altered.
One of those makes it so the user can't resize the form. I need resizing because I'm having an issue with Access resizing forms (making data/buttons not visible in the form) for a yet to be discovered reason.

[orange]

Just curious-- Is it possible that you can tell (because of user, or process or XX) in advance that you will need to resize a form?
Isladogs has some form resizer code/articles that may be applicable, if you can tell in advance and and set up the logic.