Any way to set it up so when a certain form opens or when the DB opens it pre-loads all data into memory to allow for faster searching?
thank you

Haven't tried it before, but I guess you're talking about disconnected recordsets.

Try doing a search on "disconnected recordsets" and see if that will work for you.

Hope that helps...