Combox Box Outputs the ID in text

[Alexandre Cote]

I have a table that containts a foreing key with many companies. Of course, to maintain referential integrity, I used the ID. Unfortunately, that makes it difficult for the user, considering there are a thousand keys for all the comapnies.

So I used a combo box to select the right company, which works perfectly, you see the number and the name, and then you can select the one you want, and it only puts the number. I jumped in joy, until it told me that the fields didnt match, and that i was trying to insert text in a number field (which is false, because it was a number). The source was a Autonumber, and the FK was a number. Why in the world is access telling me im outputting text... WHYYYYYYY.. ???

[jzwp11]

What is the bound column of the combo box?

If the row source of the combo box looks like the following, the bound column should be 1:

SELECT IDfield, textfield1, textfield2 etc.
FROM yourtable

[Alexandre Cote]

Wow so much wasted time for such a little problem. THANKS!

[jzwp11]

You're welcome. Sometimes it is the little things that get us!