Passing data from one form to another

[DEMONDES99]

Hi

First post. i haven't done VBA in a while, I moved onto Witness software so i'm a bit sketchy.
I have 2 forms. One needs a specific access password, which I have done however based on the password, I need it to select specific range of sheets the user is allowed to see.

I have tried this 'frmPassword.EOPASSTEXTBOX.Value = frmsheetselect.EOPASSTEXTBOX.Value but it doesn't work.
So EOPASSTEXTBOX is the password data that I need the next form to retain but when it goes to initialise, it empties again.

Any help appreciated

[Kaper]

Store the value in public variable before closing first form.