login driving auto populating

[Chekotah]

Scenario,



Have a form that the employees enter their daily hours in (production based company), I would like to have two fields to auto populate when the employee logs into the db. The two fields are their name and employee ID.

Currently my db has it when the employee chooses the form it will ask for parameters to add their employee Id several times which I do not want them to do that. I have tried doing look ups to a query as well as a table however it still continues to ask for the parameters.

Any suggestions or recommendations on how to get the form to open with the information already populated into the fields based off their login.

[June7]

What I do is at login I save the user ID to a textbox on a form (Main Menu) that never closes. That way the ID is always available for reference.

[Chekotah]

Hi June7,

I have been trying to set the log in form to invisible. However getting a debugging code error. can you give me an example of what you are talking about.

[June7]

Something like:

DoCmd.OpenForm "MainMenu"
Forms!MainMenu!tbxUser = Me.tbxUserID
DoCmd.Close acForm, "Login", acSaveNo

Post your code for setting login form not visible.