I have an input form that is prompting the user for
a location to search a table on. I made a command button
that takes the value from the textbox and uses it in a query. The problem is it dosen't work.
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.
Bob Sides
SDGS
Vermillion, SD