"Index not Found" error - solutions?

[MrDeveloper]

Hi,
I have started to come across the error message "Index not found" when accessing a form.

I have a main form which display a list of details about a person, and then a button that links to a pop-up form which gets related information to that person from a second table (i.e. a second table stores a list of different address details for that person on a 1-to-Many basis, which the pop-up form displays).

When you click on the button the pop-up form displays but immediately comes with this error. Click 'ok' on the error and the form closes, no activity can be completed.

A search has only showed info about this error in relation to importing database objects or accessing non-microsoft back-ends.

Has anyone else come across this problem and know of a solution?

The application is multi-user (front-end on client, back-end on server), only affects 2 users out of several, and its an Access 2000 application.

Thanks,
MrD

p.s. apologies for posting this question previously in the wrong forum!

 

[Golom]

Are you making references to the .Index property or the .Seek method for your recordset? This error will appear if you do things like

Dim rs As Recordset

Set rs = CurrentDB.OpenRecordset ( "TableName", dbOpenTable )

rs.Index = "RecordID"

Where "RecordID" is the name of some defined index in your table. If it doesn't exist then you will see that error.

 

[MrDeveloper]

Hi Golom,
Many thanks for your response. I open the pop-up form using the standard button code Access gives you. i.e. I dropped a button on the screen and it requested which form to open and on what criteria to use to open the form and subsequent table:

Private Sub buttRefs2_Click()
On Error GoTo Err_buttRefs2_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmReferences"

stLinkCriteria = "[P_ID]=" & Me![P_ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria, , , OpenArgs:=P_ID