I have a table with 40,000+ records in it. On my form I type in a number which cooresponds to a drawing number field in my table. I use "Scan For Like(maindatatable.dmdrno, This.Value)". This doesn't take too long on my 450mhZ CPU machine but on slower machines (100mhZ CPU) it takes several seconds. What can I do to improve this. Thanks for your help.

God Bless,
S. Dyke