View Full Version : Unload Form


npierson
06-06-2001, 11:10 AM
What is the code to unload a form?

Thanks,

Nick

charityg
06-06-2001, 11:16 AM
docmd.close

npierson
06-06-2001, 11:30 AM
I tried that and DoCmd.Close acForm, "Form Name" but none of these work.

Rich
06-06-2001, 01:26 PM
You either have the form named incorrectly or are using the code in the wrong place, please be more specific on what you are trying to do.

npierson
06-07-2001, 06:25 AM
After prompting for a password using a form, I would like to evaluate whether the password is valid (I know how to do this). If it is, I would like to load a certain form and make the password form dissappear, and if it is not, I would like to load a different form and have the current (password) form dissappear. So, basically all I need to know is how to close the form.

Thanks

Robert Dunstan
06-07-2001, 07:25 AM
I'm assuming that in your password form the user has to click a button to evaluate the password. In the coding behind your command button if the password matches you need to add the line DoCmd.Close as stated by charityg. Omitting the form name argument means it should close the active object i.e. your password form.

npierson
06-07-2001, 07:30 AM
I finally got it working. Thank you very much for the help everyone,

Nick