>>I have a ComboBox with two columns (Client_Name, Client_ID). The BoundColumn is #1...I also need to know and use the value in column #2...
>>
>>How do I access the column 2 info?
>>I know I could change the boundcolumn get This.Value and change the boundcloumn back...but that's dumb....
>>
>>What is the right way?
>>
>>TIA
>>Rick
>
>If combo.rowsource is fields or alias, then you check rowsource field values in current record, or to feel safer you can:
>
>IF SEEK(thisform.combo.value,"clients","id")=.T.
> nClientId=clients.id
>ENDIF
>
------------------------
Thank you for your input. I ended up using a select into a cursor for my rowsource, because I needed this combobox ordered by the client name...the rest of the form was based on the client ID....so I get the info I needed by temp.client_ID...
Rick
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only