how do you "showmodal" a form and get a response

[BillNielsen]

I would like to display a form similiar to a messagebox that asks the user if they wish to continue. Something like:

If MsgBox(cAreYouSureChange & sPrevAdd & Chr(13) & "To: " & sEditedAdd, vbYesNoCancel, "Verify?&quot = vbYes Then

but I cannot use a simple messagebox. So I would like to create a form that returns a boolean response. I know I could create a popup form and use a public boolean variable and depending on which button is clicked, I could set a response. However, I feel there is a better way to do this that I haven't discovered yet. Can anyone share a method of creating modal form?

Thanks,
Bill N

 

[vickvickvi]

your solution seems to be the idea that I would choose. You white a VB box and insert the DLL into the access database. that is a lot more trouble than your first solution.

sorry I do not have a solution for you.

Good luck and post your solution when you figue it out.

vickvickvi
michael Vick