Form Field Update

[merciless32]

I have a front end user login. It's linked to a table containing the user ID, password, and actual name. Once the user succesfully enters the ID and password I want a second form to open. that displays the appropriate name for the person logging in. Make sense?

Example...

James Dunn enters his login ID and password correctly. I want the next form to open displaying Mr. Dunns name in a text field at the top.

Thanks for the help! You guys are awesome!

 

[Jack Cowley]

You can pass the users name to the form using the OpenArgs argument of the OpenForm method. Or you can create a global variable, set the variable to the name then read the variable in the form. Search Access Help for the details on using OpenArgs.

hth,
Jack