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"