Create Log In and Password Page

[AmandaBurlingham]

Hi, any help with this would be appreciated as i am not sure what to even search for in help. I have created a log in page which will eventually open on load, it has a drop down field with user names where the user can select their name and then i require individual passwords. Is this possible. I would like various forms completed with an 'updated by' box each time something is changed sO i don't want user() to be the name on computer. Hope some of this makes sense!!!

 

[shadow9449]

It certainly is possible.

The way I do this type of thing is to hide the login screen once the user has filled it in. Then your application can set a field on the data-entry form(s) to the user's name. You can reference it as something like this: Forms![frmLogin]!txtUser. I don't know exactly which part of this you are finding difficult so if this information doesn't help, please specify what area you are having trouble with.

 

[AmandaBurlingham]

Thank you, i have now a combo box with a few peoples names on frmLogIn and a Login button. I choose the name then click login and the form closes whilst opening frmMain. I have a text box which i want to show the name of the person logged in but if i type Forms![frmLogin]!txtUser it just comes up with #Name?. Do i need to change txtUser to BD_ID which is the only field in the table with the login names. Sorry i have only been using access about 6 months and i am only self taught !!!

 

[shadow9449]

T...and the form closes whilst opening frmMain.

There's your problem. You are trying to reference a field on a form that isn't open anymore. My recommendation was to hide the form rather than close it.

How about trying something like Me.Visible = False

Cheers

SHADOW