Form as MsgBox

[mcalex]

Hi all

I'm looking for a thread on how to use a form as a MsgBox. I've seen this posted as a solution to customising a prompt as in 'how do i set different colours/fonts/buttons etc in a MsgBox?' and I want to give it a shot.

My problem is how to call a form to return a value. Ie, i'm looking for the syntax equivalent to:
if ((MsgBox, text, vbYesNo) = Yes)
something like:
if ((DoCmd.OpenForm "frmName",,,,,).btnOK.isClicked)

can anyone point me at a link

cheers

 

[Galaxiom]

Each diffierent response button on the form would have its own click procedure.
The procedures close the popup form. The yes button opens the new form as well.

 

[mcalex]

Ok to the response buttons having their own click procedure.
Ok to these procedures closing the popup form,

but the 'new' form will still be open in the background. On hitting yes, I want to close the (popup) form, and follow the 'True' path of the if branch

I can't set myForm = true in the click procedure can I?

basically, the user has performed a bunch of actions, and just prior to committing all those changes, I'm popping up a change list for confirmation. the psuedo code is

if (user clicks OK on popup form)
commit changes
else
rollback changes
end if

should i be doing it another way?

thanks for helping

mcalex

 

[Galaxiom]

I thought once a procedure is started it runs until complete even if the form is closed by that procedure before it is completed but I haven't tried it.

If not then save a value corresponding to the button as a variable and then close the form. Test for the variable in the On Close event of the popup form. This procedure will complete and then close.

 

[khawar]

Have a look at my custom message box sample Here

 

[mcalex]

thank you Galaxiom, Khawar,

got it sorted. I think i was making it too difficult.

cheers