Operator name in text box

  • Thread starter Thread starter faapa via AccessMonster.com
  • Start date Start date
F

faapa via AccessMonster.com

Hi

I was wondering if someone can help me out -

I have a database that stores employee information. When a user enters
details regarding an employee, i would like a textbox to be able to
automatically store the name of the user who has entered the details on the
form. The name of the user (the person typing in the info) should come
directly from their Windows user name (operator)

Hope that makes sense!
 
thanks Allen that works perfectly! I just have question though - does the
username get stored in that field or would it change depending on which
windows user is running the database?
 
If you set the ControlSource of the text box, it changes depends is logged
in, because the value is not stored in a table.

If you set the DefaultValue of the text box, the value is assigned when you
create the new record, stored in whatever field you named in the
ControlSource, and therefore stays that way in the table.
 
Back
Top