>>Here is the code in the click event
>>select*;
>>from lithdata!litdesc, lithdata!lithhead;
>>WHERE Lithhead.location = Lithdesc.LOCATION;
>> AND Lithdesc.location = this.location;
>> ORDER BY Lithhead.location, Lithdesc.depth
>>
>>The problm is with this.location which is the name of the textbox where the user inputed the location.I get the error message: Operation invalid for a memo, general, of picture field. Can anybody help with this problem. Thanks for all the help.
>
>It's really bunch of problems:
>1. Fox message tells you that you cannot order by Memo field (Iguess location is Memo).
>2. Also what is This.Location?? It will be understood as custom property of active form. Otherwise you should put something else like thisform.txtBox1.value or even better add line:
> cLocation=thisform....
>and use it in SELECT.
That did the trick, Thanks for the help
Bob Sides
SDGS
Vermillion, SD