Re: Setting index for DAO Recordset - WHAT AM I DOING WRONG??????
Originally posted by DoktorBlue
You have to specify the index name, not the column's name! You can look up the index name in the table's index collection.
Yes I know. The thing that was confusing me was that every index in the table's index collection has the same name as the indexed field in the table EXCEPT THE PRIMARY KEY whose name in the index collection is apparently "PrimaryKey", not "Reference" or whatever the field is named. So I had 3 indexed fields in my table...Reference(the key), DateNo, and Sender. I assumed the names in the Index collection would be "Reference", "DateNo", and "Sender" but they are "PrimaryKey", "DateNo", and "Sender". Thanks.