>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.
Edward Pikman
Independent Consultant