Auto select value: form

[Gilgamesh]

Hi:



Im making a new database in order to save time when we receive a new work order at my job. I dont have much Access experience but I've been able to create a database to do it, unfortunately there's no way for me to insert a field in the form in such a way that the "Email" field is automatically filled when the "Requester ID" is selected.

Hope you can help me with this problem and thank you in advance.

PS: See enclosed DBxxx.accdb

[John_G]

Hi -

I don't have A2010 so I can't see your database, but one option is to use dlookup in the After_Update event of the "Requester ID", somthing like this:

me!EMail = nz(DLookup("EMail_Address","Requestor_Table","Requester_ID = " & me![Requester id]),"N/A")

replacing the italics with the actual names of your table and fields.

I used the Nz function to insert N/A in the field if there is no E-Mail address.

HTH

John