Making form code stop for password

[Simon Phillips]

Can anyone help with this problem please :

I have an order entry form on screen and if the user presses a certain button I want to be able to ask for a password before allowing them to perform the action. My problem is that when I .show the password entry form, code execution in the original form carries on. I want to be able to halt code execution in the calling form until the user has either ok'd or cancel'd in the password form !

[John G Duffy]

formx.SHow VBMODAL



will do the trick. VBMODAL will suspend execution in the calling form until the called from is closed. THe only trick is to get the users response back to the calling form. Place it in a global variable somewhere for the calling form to interrogate.

John G