>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

Why not have a view that returns all hits to a grid so the user can decide which one they really want?

create sql view 'lv_drawing_list' as;
select field_list ;
from maindtattable ;
where dmdrno like ?vp_drawing

You can change the like with = if you like.

vp_drawing is the control source of the form.

Then a requery() is all that is needed in the code that fires to fetch data.

__Stephen