Pop-Up? Modal? or something else? 2

[telephoto]

I am trying to get a form to act as a dialog box, but the vba which opens the form just carries straight on.

Background: I have a choice of two reports to select from, called rptOriginal and rptNew. The selection form has two command buttons which set a global variable to the required report name, and then the form closes.

What happens: The selection form opens, but the calling sub routine doesn't wait for the variable to be set.

Question: How do I get the calling form to wait for the variable to be set before continuing?

Telephoto

 

[strongm]

Use a UserForm instead ...

 

[MajP]

DoCmd.OpenForm "frmSales", acNormal, , , , acDialog

The sixth paramater is acdialog in the windowmode halting code execution.

 

[telephoto]

That was interesting!!!
Never heard of it before, and getting information was not obvious. I could only find references to Excel.
If anyone else wants to know, then this link may help:

http://www.pcreview.co.uk/threads/how-to-create-a-new-userform-in-access-vba.2424570/

it did at least give me a starting point.

strongm - thanks a lot, take a star

Telephoto

 

[telephoto]

MajP
didn't see your reply until I'd sussed out the userform business, without checking, it looks easier! please accept a star as well.

T