Putting a password on the after click of the command button

[shapman]

Hi

I wondered if there was an easy VBA code for putting a password in the after click event of a command button, i.e. the command button opens up a form, but to get to the form you need to enter a password. Im guessing this would be in the Afterclick code before the command to open the form.

thanks in advance

Shapman

 

[Dennisk]

you need to proceed the open statement a dialog form to obtain the password. If the password is valid then open the main form.