Combo box returns a number

[Aztecfan63]

My combo box seems to return the correct text from the specific table used for that combo box in my form. BUT the query
receives a number? what am I doing wrong?

[Welshgasman]

Depends on what your combo contains?
I tend to have the bound column as my first column, which is always hidden, the the descriptive column as my 2nd and any other columns after that.
However the key that everything is linked by is the first column, usually an autonumbet.

[June7]

That's how multi-column combobox should work - assuming you are using autonumber field as primary key and saving that value to dependent table as foreign key.

Where are you using this query - form or report?

Advise not to build lookup fields in tables.

[mike60smart]

In your query you would include the table that contains the values for your Form Combobox and
you then add the field from the table and not the ID number from the related table.