Customizing Display of Combo Box

[Dina01]

I have a combo box that is bound to an SQL statement..

SELECT Effectif_tb.Poste, Effectif_tb.Agent, Effectif_tb.NoAgent FROM Effectif_tb GROUP BY Effectif_tb.Poste, Effectif_tb.Agent, Effectif_tb.NoAgent;

I have it showing 3 fields... but I want it to show only one field... and I don't mean when you click the drop down for the listing... I want it to be shown on the screen when the selection is.

When I click on the drop Down I see the followinf..

Poste Agent NoAgent

But how do I select and then after I want only the NoAgent to Show, because that is what I save to my table.

I looked at the properties and I set my
ColumnNo to 3
ColumsWidth to 3.219cm;3cm;1cm
ColunLink to 3

Can anyone clue me in????

 

[petersdaniel]

Set your columns widths to 0,0, 1cm petersdaniel@hotmail.com
"If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein

 

[rajeessh]

Set your columnWidths as 0";0";1"

If then u need the bound column to be 1 or 2 or 3

decide and set the bound column property of the combo
box??

 

[Dina01]

Yes, but 0;0;1 only shows the NoAgent, but I want the user to see all the data when he clicks on the drop down and when he let's go of the mouse the selection showed only show NoAgent, Also I need to see the dat in the order of...


Poste Agent NoAgent

 

[rajeessh]

Have the column widtbs as 1";1";1"
the set boundcolumn to 3 in case of u wish
NOagent to be selected in combo