>>>>>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.

Would this work?
Instead of a SEEK in the Keypress method, do a "Select ... where eval(Key(n))<[Key Pressed]" and use _Tally + 1.