Login Problem

[Guest]

HEEELLLLPPP! How do I get a textbox to reflect the username after a login on
a different form. I have five forms and I need to have the username name
reflect on each. NB I have a table called users and another called login
which records the user logged in

 

[Graham R Seach]

If all you want is the username, put it in the Registry! The general
syntaxes are:
SaveSetting appname, section, keyname, value
GetSetting(appname, section, keyname, defaultvalue)

To store the username to the Registry:
SaveSetting "myAppName", "Settings", "Username", Me!txtUserName

To retrieve the username from the Registry:
Me!txtUserName = GetSetting("myAppName", "Settings", "Username", "")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia