populate text box from another table

[elfranzen]

I have a table that logs the person that is logged in and what time
I would like to use this information so when they are inputing records it will pull their name from this table(LogInTime) and auto populate the Dispatcher that is making the call(this information is logged in another table "HeatTicketTable") how can I do this. would like to auto populate this field on open.

 

[agehoops]

Declare a Global Variable, which takes the username when the user logs in, then when you open the form, or at whatever event you want it to happen, run an UPDATE SQL string to add the name the field in the table, or if the form is based on the table you want the name stored in, then just add the field to the form (can be invisible) and when it loads or whenever you want, just set its value to the variable storing the name.