Using a Login Name as a default value for a field

[jackyaz]

I'm not sure if this is the right section, but here goes. How do I go about creating a simple login form, that remembers who you have logged in as, and then sets this name as the default value for a textbox on a form? A password for the login isn't really necessary, if that makes matters simpler. Many thanks in advance.

 

[dbDamo]

If you don't require a password then you don't need a login form, have a look into the Environ("username") function...

 

[jackyaz]

oh okay then, i'll have a go with that

edit: just seen what that does. some of the computers we'd be accessing the database from have usernames such as "Shared", as they are a shared user. On another database I've seen there is a form at the beginning with a combobox that lets u select a name, and then opens the database, and this name is used in forms. I dont have access to the database anymore as it was over a year or so I saw it last. How can I achieve this?

 

[dbDamo]

I have always used that function so have never needed to create a login screen. Have a search on this forum, there are loads of threads with people asking the same thing.

 

[jackyaz]

Ok then, cheers, I shall have a search

 

[jackyaz]

Thanks, I found an example which I have got to work perfectly, using some customization of course!