Re: MsgBox Function Explained?

Jeff C wrote:
OK Guys, let me see if I understand correctly. I design a dialog
form that will display the query results I want to look at. Being in
Dialog mode, this in itself will stop the sequence. I can tie events
to the onclick properties of command buttons, what action tells the
sequence to continue? I can label one "do you want to continue? But
what will it's event be? I really appreciate the help. Thanks

First off it will have to be a form with a ListBox to display the query results
or a continuous form that displays the query data directly. A Data*** form
cannot be opened with the acDialog argument (it will be ignored).

Second, your code wil continue as soon as the dialog form is made hidden or
closed. Normally, you would have one option hide the form and another option
close it. The line of code immediately after opening the form can be used to
test if the form is still open (which will mean you chose one particular
option). If it is NOT open then your code "knows" that the other option was
chosen. If one of the options needs to examine anything on the dialog form then
obviously that option is the one that should hide it rather than close it.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.