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?