Connecting a combo box to a text box

[woknick]

I have a combo box that uses a query to display account numbers. I also have a textbox which I would like to display a requestors name. The requestors name is associated with the account number.

so when you select the account number, I would like the textbox to autopopulate the requestors name and then from there ill use that name to email a completed order.

Thanks in advance

 

[KenHigg]

In the cbo box's after update event, do something like:

me!myReqNameTextBox = dlookup("[myReqName]","mytblAccounts", "[myAccNumber] = '" & me!myAccNumberComboBox & "'")


Would this work?
kh

 

[Rich]

Add the customers table to the combo box's underlying query, just add a second column which has the customer name in it, then you don't need any code or DLook ups

 

[KenHigg]

Excellent suggestion - never thought of it!

kh