>>>>Is it possible to get the numeric position of a record when a table is viewed in indexed order? Something like a logical *indexed* RECNO()?
>>>
>>>Do you have a primary key field on that table? Could that be used?
>>
>>Yes, I have a primary key as part of the index in question. How can I use this?
>
>I was just wondering what would be a use to get the positioning of the record within your SQL. Can you tell us more what you are trying to achieve?
Thanks for your interest, Michel.
I am trying to rapidly get to a position in the LIST of a combobox, without evaluating the list using FOR...NEXT to the length of LISTCOUNT.
Therefore, I do a SEEK of the source table from within the Keypress method. If the data coming from the source table is SELECTed into the rowsource in 'natural', un-indexed order, I can use the RECNO() after a successful seek as a pointer back into the combo box's LIST.
However, if I SELECT for my ROWSOURCE with an ORDER BY clause, the RECNO() has become meaningless... That's why I would like to know...
I hope this makes it clearer.
On a CLEAR day you can see forever.