hi guys,

i have this same set of codes in 2 different forms in seperate standard EXE project.while the code in one form is working the other is not working.

i also swapped the forms between projects only to confirm that all the seeks in that particular project is not working while the same form in the other project works . is there any one who can help me out.


Dim rs78 As Recordset4
Dim data78 As Database

Set data78 = OpenDatabase("c:\kskvb\walmart1.mdb")
Set rs78 = data78.OpenRecordset("stores", dbOpenTable)

With rs78
.Index = "primaryKey"

.Seek "=", "0015"

If .NoMatch Then
GoTo 10
End If
End With
>10:

the error message was "methods or data member not found" at the .index = .... statement.


any help is appreciated.

Regards
shashi