Hi

In vb i get error 3015 where it says idx(field name) isn't an index in this table. Look in the Indexes Collection of the Tabledef object to determine the valid index names.

I have Access97 database and checked that the field i mentioned is indexed(Autonumber).
I get error on the Redline given below.

Can anybody help on this please.

Private Sub Form_Load()
'------------------------------------------------------------------------

CenterForm Me

OpenhrDatabase

Set mobjCandRst = gobjhrDB.OpenRecordset("Candidate", dbOpenTable)
mobjCandRst.Index = "idxcandidpk"

mblnOKToExit = True

cmdFirst_Click

End Sub

Solved the bug by myself...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.