DAO - using the indexes of the table

[Crookshanks]

Hello there,

I've got a very small and probably very simple question. In my database "contact" I've got two important fields:
- Organization
- Name_contact
In the table definition I created two indexes named after the above mentioned fields.

Depending on a variable the index is set to
RsCon.index = "Organization" or rsCon.index = "Name_Contact"

Now I want to loop through the table in the order of the index, so i wrote:

     Do While rsCon.EOF = False
       If rsCon![Selected] = True Then
            'do some kind of action     
       End If
       rsCon.MoveNext
    Loop

but the order in rsCon.Index is not reflected in the Loop. Question: what am I doing wrong?

I realiaze that it is probably very simple but I am stuck (damn those monday mornings).... Any help appreciated.

Kind regards,

 

[Crookshanks]

Sorry, my bad. The above works, but I had to restart Access.

 

[Golom]

It may work now but there's no guarantee that it will always work.

Indexes are used to search the database but there is no assurance that records will be returned in Index order if you don't use an Order By clause when you retrieve them.

 

[Crookshanks]

Thanks for your tip. I will implement a query instead.