Populate unbound text box

[kfoley]

Instead of using a subform to do this, can I populate a text box based on the value another text box?

I have one field that displays a name, lookup list that uses the AddressBook and return the PersonID. Once the name has been selected using AfterUpdate I want to populate the next textbox with the email information.

This is the basic logic

email.text = tblAddressBook.email where me.personID = tblAddressBook.personID

Any ideas? Hopefully I have explained this correctly.

Kim

 

[FoxProProgrammer]

Sure, you can do this. Does the form have a Recordsource or is it unbound? If it is bound, is the record that contains the email address in the recordset? Based on your answer, I can suggest a method to retrieve the email address. dz
dzaccess@yahoo.com

 

[jebry]

Hi Kim!

You can do it like this:

email.text = DLookUp("email", "tblAddressBook", "[tblAddressBook]![personid] = '" & Me!personID.Value & "'&quot

this assumes that the personid is text. If it is numeric then you will not need the single quotes or the last set of double quotes.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[baltman]

Jeff,

Thank you so much it works like a dream.

Kim