I need to create a custom dialog box. When you code an input box, the VBA code halts and waits for the user input, and, in fact, the input box returns a value that represents the user's action.

I need to do the same thing, but with a regular form. Basically, I need the VBA code to halt and wait for user input, and upon closing, return programmatic control to the calling code.

Please help! This would be an enormously useful thing if it can be done.

Thanks,

Snakedog

Okay, wait a minute, I got it!!!!

Let's say you want to open a report, but you want a custom dialog box to open, to, say, allow you to create a filter for the report.

-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
DoCmd.OpenForm "Form1", acNormal, , , , acDialog
MsgBox "done"
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

... it's the "acDialog", which I swear I tried before, but whatever. The return value may have to reside in a public variable, don't know yet.

Cheers,

snakedog