Hi,
My program crashes whenever I click the button, this button has a code to search for a data in the Access data file .mdb :
The code is :
.Seek Array(CStr(rstContract!ContractNo), CStr(strMonth), CStr(strYear)), adSeekFirstEQ

The index file in the .mdb is :
Contractno (and have indexes 3 fields) field1, field2, field3

Note:
The system crash stops when I change the code to the following, like searching only for one value (field):
.Seek Array(CStr(rstContract!ContractNo)), adSeekFirstEQ

What I did:
- Reinstalled VB + SP4
- Reinstalled Access þ2000þþ

All what I did, didn’t help, problem still exist?

Any advice please