Having trouble transfering text in forms

[supa_sumo]

Can you work out whats wrong with this I used the sample database password system and tried to add a button to enable the user to change their own password. The problem was at the time that the change password form must open displaying only their own username, this is where the complication starts where i try to transfer UserID from the menu form to the Change password form.

Any Ideas Im a bit confussed.

P.S
Only left what was needed in the dadabase

 

[WayneRyan]

supa,

You have a few options here.

You can declare gblUserName and gblPassword as Public variables
in a module. Then your login form can set them and your whole
app can use them. Set them right before you close the form and
your whole app can still retrieve username/password.

You could use the "OpenArgs" when you chain to the next form.
Not a good solution because you'll have to be constantly parsing
them.

You can also minimize/hide the login form instead of closing it.
Then your other forms can use references like:

Forms![YourLoginForm]![txtUserName]

Wayne

 

[supa_sumo]

thank u v much got it working now