>>Okay, I've got this Access database with one table that has 2 fields and an index, idxScore. All I want to do (at this point) is display the records from the table based on the index so that they will be in numerical order. I can get the records to display, but I can't seem to get them to index right.
>
>Are you using DAO, ADO, something else? Are you trying to do this within Access or a VB application? Could you be more specific about the method by which you have gotten your result set.

Thanks and sorry... wasn't sure what specifics would be needed and was trying to balance presenting enough information without going on and on.

I believe I'm using DAO. But what would be a definitive way for me to tell? I'm really brand-spanking new to VB. And I'm trying to do it within the VB application. I used the Visual Data Manager add-in to create the table. I got the result set by:

<p>
    strdbname = "c:\bardice3\hiscore.mdb"
    strrsname = "hiscore"
    Set db = DBEngine.OpenDatabase(strdbname)
    Set tdfHiScore = db!hiscore
    Set rs = db.OpenRecordset(strrsname, dbOpenTable)
    Set idxScore = tdfHiScore.Indexes("ScoreIndex")
    tdfHiScore.Indexes.Refresh

I'm not sure how much of tis is necessary. And, lthough it will let me set and refresh the indexes it doesn't appear to have any effect on the resulting ordder of my recordset.

Thanks again for the help!!