Lookup fields from another table based "afterupdate" from a combo box

[allenEd]

Hi,



Best explained as the example. Say I have two tables tblContacts and tblServices. In the tblContacts, there are the fields lastname, firstname, address1, address2

In the tblServices there is a lookup to the field "lastname" in the tblContacts table. In a form with recordset tblServices, there is a combo box for the "lastname" field. How do I get a textbox to display the firstname based on the combo box (lastname)?

thanks
Allen

 

[dhookom]

What happens if you have two or more contacts with the same last name?

Generically, your combo box can have 1 or more columns. To display the second column from a combo box in a text box, use a control source of:
[tt][red]=cboLastName.Column(1)[/red][/tt]


Duane
Hook'D on Access
MS Access MVP

 

[allenEd]

Thanks Duane,

thats really simple! The db was just an example, the "surname" wont be the same. I just wanted to know how you do it.

cheers