Accessing correct Combo box column from Query

[spidey1]

Hi everyone,

I have a combo box that is populated from a table called tblProducts.
There are only three fields ID, Model and Description in this table.

ID is the primary key field and is an Autonumber

In the form when a user selects a product from the combo box the "Model" fields is displayed which is how I want it.

I am doing a query that should show the "Model field however when I run the query it shows the "ID" field which is useless information for the end user.

How do I show the correct field in the query?

 

[ted.martin]

Have you tried specifying in the combo properties the Coumn Count and Column Width parameters. For example, evn though the 'bound' column will be Column 1 (ID), to show the Model in the combo, set Column Count = 2 and Column Width to 0cm; 3cm
Hopefully this will do what you require.

 

[spidey1]

Hi Ted,

I tried your advice, but it still displays the ID field in the query. However now it displays the ID field in the form as well.
I'm not sure why this is happening.

 

[ted.martin]

zip the file and post it so I can see what you mean. Just a few lines of data will do so copy the file and delete most of the table entries

 

[MStCyr]

Set your column widths to 0", 1", 1" so that column 1 will be hidden

 

[spidey1]

I have, the ID column is hidden and it displays the correct field in the combo box on the form. It's just when I run the query it shows the ID column for some reason.

 

[neileg]

Have you joined tblProducts into your query so you can pull the model field instead of the ID?

 

[RoyVidar]

neileg is probably spot on - you're probably using a lookup field in your table, and experience one of the many reasons why many of us recommend against it.

See for instance http://www.mvps.org/access/lookupfields.htm for more info.