combo box from a query

[DanielS]

I have two combo boxes on a form. I am trying to use the
first one as a query criteria to "filter" the available
choices for the second combo box. The query is set to run
at runtime. It seems to be working somewhat but my
problem is that Combo Box 2 shows the wrong column.

Here is my generic query code:
SELECT Table.Column1, Table.Column2 FROM Table
_WHERE (((Table.Column2) = Me!Combo1))
_ORDER BY Table.Column1 ASC

When I select a value in Combo1, the resulting selections
for Combo2 are coming from Column2 but I want to see
Column1. How do I change which column is displayed in
Combo2?

 

[Ted Allen]

Hi Daniel,

A combo will normally display the first column, unless
the column width of the first column is set to 0. Check
the column widths, and also check the order that you have
selected the columns in.

HTH, Ted Allen

 

[John Vinson]

How do I change which column is displayed in
Combo2?

Either change the order of fields so that the column you want to see
is first, or change the ColumnWidths property of Combo2 to set the
width of the column you don't want shown to 0.

 

[DanielS]

Many thanks to both John and Ted. A very simple
solution, but I couldn't figure it out. At some point I
had set the column width of Column1 to 0. All better now!

Thanks fellers.