combo view specific coloum

[romanticode]

my combo box using first coloum of query as criteria field, and third coloumn as display on form?

i have try many ways but nothing work.
how can i do it?

 

[RuralGuy]

A ComboBox will display the first visible column when it is quiescent. Change the order of your columns in the RowSource of the cbo.

 

[romanticode]

stiil dont get work, can u give example?

 

[ShaneMan]

stiil dont get work, can u give example?

Have you double checked to make sure your column count for the cboBox is 3 (if 3 columns is all the cbBox has) and then the Column Widths should look like this: Column Widths 0";0";1" ??
The zero's are, of course, not going to show. You can play with the 3rd number to get whatever width works for you.

HTH,
Shane

 

[RuralGuy]

Please post the SQL for the RowSource of the ComboBox.