Log on form

[themastertaylor]

I'm looking to create a log in screen for my database, i don't need a
password on it so the form design itself will be a simple combobox,
what i want to do is somehow have the system store the current user
and enter it alongside the orders logged within it. basically so that
i can login and have my name against the orders i place, and likewise
for other employees. i can see this in the northwind database but
working it backwards is prooving a bit beyond me!

 

[bcap]

Once your user has logged on, don't close the login form, simply hide it:

Me.Visible = False

Then , whenever you want to get the user's name, you can grab it from the
hidden form with an expression such as this:

Forms!frmLogin!cboUserName