Text Box data contingent upon previous combo box

[tjcinnamon]

I have a combo box where I select a Hardware store. I want the address for the store to come up if a hardware store is selected. If one is not selected I want to be able to enter an address.

I have a vendor (hardware store) table, which contains the Hardware store and it's address. I can get the combo box to show the store selections but I can't get the address to come up after I select the store.

Is there a way to link text boxs to a combo box??

Thanks, Joe

 

[FoFa]

Typically on the CLICK or CHANGE event of the combobox, I'll use code to go get that data and populate it in the text box.
OR you can base the text box on a DLOOKUP that references the combobox, then all you need to do is refresh (requery) the text box after selection has been made.

 

[tjcinnamon]

I tried the DLookup and still wasn't able to get it to work perhaps I did that wrong. Here is a copy of my database. Again I need the address to correspond to the selected vendor.