Kevin,
Change the order of the SELECT statement (see below). Set the boundto property of the combo to 2 (to bind it to the second field). Columncount should be 1 if you don't want the initials to appear.
>I want to build a combo class for users. The combo should have
>2 columns, Initials and Full Name.
>
>I have the following:
>
>
>SELECT FullName, Inits;
> FROM Users;
> ORDER BY 1;
> INTO ARRAY aTemp
>
>IF _TALLY > 0
> =ACOPY(aTemp, This.aDataItems)
>ENDIF
>
>.RowSource = "This.aDataItems"
>.RowSourceType = 5
>
>
>
>This works fine, to a point. When I pop open the list, I see the
>2 columns, Initials and Full Name. When I select an item, I see the
>users initials. What I'd really like is to see the full name, but store
>the initials.
>
>Any ideas?
>
>Thanks
Steve Gibson