>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)".

You could convert the entry from text into an integer (or float) then SEEK the value indexed on a numeric field. (If the drawing numbers have characters in them 850a, 850.1c, etc., then you'd have to go with the padded character string)

In either case, there is no reason to use a scan..endscan if you're looking for only one record. (assumeing each drawing number is unique) Use SEEK directly on an indexed database.