Store/show both columns of a combo box

[HVACMAN24]

I have a combo box that displays 2 columns when clicked. First Column contains a number and the second is a description. I want to be able to select the appropiate item and then show both values in the box and also store both into the table. How do I concatenate or get them together to accomplish this? I'm assuming if I can atleast get them to display in the box together that they will store in the table the same way.

 

[John Big Booty]

There should be no need to store both values IF your table structure is properly Normalised.

There are a number of way that additional data from a combo box can be displayed on a form. The easiest is to display it in an unbound text box, using the following in it's Control Source;

=YourComboName.Column([B][COLOR="Red"]x[/COLOR][/B])

Where x represents the column number in the combo that holds the data you wish to display. That column need not be visible to the user. Remember that the columns in a Combo (also list box) are numbered from Zero up. The first column (often bound and hidden) is column zero the second column 1 and so on.

If you really do want to display both pieces of data at once in your Combo, you could concatenate the two fields into an additional field in the Combo's Row Source using

[FirstFieldName] & ", " & [SecondFieldName]

 

[HVACMAN24]

I've tried a few things but I still cant get it. I'm still fuzzy on the normalization part of it, I dont think my database would be considered normalized. But the combo box is displaying a project number and then a description. I do want both of these, once selected, to be seen in the box and then stored in the table as such. There wont be any need to break them apart later. I had the row source for the combo box set to a linked excel file that held all this information that way when that file was updated he database was as well. But then I ended up making a table that had the numbers and descriptions, because the file had a lot of other crap in it that I didnt need and for what ever reason was messing me up. Is there a way to just code it so on change or something that combobox.value = column(0) & column(1)? I tried something similar but couldnt get it to work.

 

[HVACMAN24]

Nevermind, I got it working the way I want now. I could have sworn I tried this earlier and it didnt work but now it seems to work everytime.