Unique Lookup field

[carmenv323]

I am trying to figure out a way to default a field on my form

Example: RequestorName = defaults to system Username on the form and is the "linking field" to the Requestors table (this works find)
RequestorID = this field exists in the Requestors table and on the form's record source table
RequestorEmail = this field exists in the Requestors table and on the form's record source table

I would like to default the form's RequestorID.values and RequestorEmail.value to the values on the Requestors table but the only link is the username.

Should I be considering this in an after update, on form load or in the table itself?

All suggestions welcome!



Thank you

[Gicu]

In the form's controls (textboxes) properties screen for the RequestorID and RequestorEmail enter a dLookup in the Default Value property:

=DLookUp("RequesterID","Requestors","RequestorName ='" & Environ("UserName") & "'")
=DLookUp("RequesterEmail","Requestors","RequestorName ='" & Environ("UserName") & "'")

Cheers,