Enter records from one table to another using a form

[Silvio]

Things are much more complex but I will try to be as simple as I can:

I have two tables and one form. I am using the form to enter data in tblData.
The Record Source in my form is based on tblData. My second table is called
tblDefaultUser, which has only one record, the current set default user name.
When I enter a new record using the form I would like to automatically enter
the user name from tblDefaultUser in the new record created in tblData in the
field called User. How can I do this?

 

[Rick Brandt]

Things are much more complex but I will try to be as simple as I can:

I have two tables and one form. I am using the form to enter data in
tblData. The Record Source in my form is based on tblData. My second
table is called tblDefaultUser, which has only one record, the
current set default user name. When I enter a new record using the
form I would like to automatically enter the user name from
tblDefaultUser in the new record created in tblData in the field
called User. How can I do this?

Set the DefaultValue property of the TextBox on the form to...

=DLookup("UserNameField","tblDefaultUser")

 

[Silvio]

Thank you, it works like a charm.

Set the DefaultValue property of the TextBox on the form to...

=DLookup("UserNameField","tblDefaultUser")