I have a form with a field [ContactEmail] that I want to auto-populate with an email address based on the session UserID returned by the Active Directory login.
A table named CONTACTS is in the project and it has fields [UserID] and [ContactEmail]. There are no duplicate UserID's or ContactEmail's in the table CONTACTS.
WHERE Contacts.UserID = session("UserID")
Setting the field as a "Lookup" I can get the drop down to display the desired ContactEmail but you have to click the down arrow and select the only item on the list.
Would like to set the field as "text" type and auto-populate the users email address when "add" form opens.
Is there a better approach as I can't seem to get this working?