I can't figure why a field is not an index in the table. Error (3800) 1

[Pack10]

I am trying to use recordset with an index....
I receive an error message run time error 3800 that
"Task_Received" is not an index in this table.

I have the field "Task_Received" which is a date/time field set as the primary key, indexed no dupes in the table def.
I don't understand why I get this error.


----------------------------------------------------
Set db = CurrentDb
Set rst = db.OpenRecordset(Name:="Task_Information", _ Type:=dbOpenTable)
rst.Index = "Task_Received

 

[PHV]

field set as the primary key
I'd try this instead:
rst.Index = "PrimaryKey"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Pack10]

That was it...thank you much. I had used a construct from a Helen Feddemma book which was giving me fits.

Thanks again