Why do I keep getting this error when trying to delete a record.
"Insufficient Key column information for updating or refreshing."
This is my code:
strCriter = "[Ref ID]=" & stgrsID
gRDB_RS.Find strCriter, , , 1
If gRDB_RS.EOF Then
MsgBox "Record was not found."
Else
gRDB_RS.Delete
MsgBox "Record was successfully deleted."
End If
I also tried this one:
gRDB_RS.Filter = "[Ref ID]=" & stgrsID
gRDB_RS.Delete
But I keep getting the same error above.
Does anybody has any suggestions?
Thanks you in advance.
Lulo
"Insufficient Key column information for updating or refreshing."
This is my code:
strCriter = "[Ref ID]=" & stgrsID
gRDB_RS.Find strCriter, , , 1
If gRDB_RS.EOF Then
MsgBox "Record was not found."
Else
gRDB_RS.Delete
MsgBox "Record was successfully deleted."
End If
I also tried this one:
gRDB_RS.Filter = "[Ref ID]=" & stgrsID
gRDB_RS.Delete
But I keep getting the same error above.
Does anybody has any suggestions?
Thanks you in advance.
Lulo