>I have a table that has a field with the first word begging with the same name (ie. bean green and bean pork) I would like to do a search by typing in either partial or full word bean and view all results. The following isn't working. Any direction appreciated.
>
>
>Descr = UPPER(thisform.text2.Value)
>
>lcSave = thisform.grid1.RecordSource
>thisform.grid1.RecordSource = ""
>SELECT Name, MA, Buyer, Item, Pack, Size, Brand, Descriptio as Description;
>FROM sporder;
>where descriptio like DESCR ;
>ORDER BY Description;
>into CURSOR sorder
>thisform.grid1.RecordSource = lcSave
>
>thisform.grid1.recordsource = "sorder"
>
>
http://www.techonthenet.com/sql/like.htmDescr = UPPER(thisform.text2.Value) + "%"
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up