Connecting two columns

[jlc28]

I'm sure this is easy. I'm just slow. ha ha. Anyway, I have a combo box that lists vendor names. Now I want the vendor ID number to be automatically shown in either a text box or list box, whatever. I just want the ID number to show, that corresponds to the vendor name. Help! The ID and the Name are in one table.

 

[bradcccs]

Assuming that your combo box has column(0) (first column = Vendor ID ) bound but hidden, you could use for following in a text box for display:

=cboComboName.Column(0)

 

[jlc28]

Uh?

=cboComboName.Column(0), I placed this in the controlsource of the textbox and I get that error "#Name?". Any suggestions?

 

[bradcccs]

You need to replace cboComboName with the name of your combobox.


=YourComboBoxName.column(0)

 

[smercer]

I am not quite sure what you mean. But I have a combo box that shows the surname but when you click on a name in the list it saves as the ID number but still shows as the surname.

is this what you want?

 

[jlc28]

Bradcccs = I did have the right name but for some reason it wasn't working. However, I left it for a few days and redid it today and now it works. Maybe I had some properties messed up. Who knows.

Smercer = I actually wanted the person to select based on the name and then in another box, the corresponding number would be displayed. I wanted to be able to see both.

Thanks to both of you for your responses. It helped a lot.