Double Indexes

[TomJaep]

Can anyone help, I want to search a recordset using 2 search criteria. The way I do it is:-

Recordset.seek "=", Var1, Var2

But I can't remember how to set up my indexes.

I think it's somthing like :-

Recordset.index = "Index 1", "Index 2"

But it doesn't work Please Help !!!

[odysseus]

thats true. but you should set up your indexes in your database table like indexes.

[szlamany]

Why are you replying to a vague post from 5 years ago?