custom Dialog Box

[GBalcom]

Hello,
I'm trying to satisfy my need for a custom dialog box. My box needs 3 options.

• Ignore Products
• Choose from all Products
• Create a Placeholder product

This will be called within a code block (Recordset Loop). I would usually use a custom popup user form for this, but I need the code to stop executing until a response from the user has occurred. Any Ideas?

 

[pbaldy]

Open the form in Dialog mode. Code will stop until it is either closed or hidden.

 

[pbaldy]

This sample db uses that method:

http://www.baldyweb.com/WrappedForm.htm

 

[GBalcom]

Pbaldy,
Your excellent response couldn't have come at a better time. I found exactly what I needed in your db.

 

[pbaldy]

Happy to help!