-
Hi Bashfirst
There must have something I miss.... Now I have an other adodc error message say "Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', OR 'UPDATE'"
I have try to use different field name to test out if I have miss spell any of my field name ... but the result come out the same....
I even copy and paste the command U write to me still same error message come out...
Also another error message come out when I try to compile my code ... say "The Microsoft Jet database engine cannot find the input table or query "select *from order where suppl_no = '"&text1.text&"'" ... make sure it exists and that it is name is spelled correctly....
What did I miss or do wrong....
I have my mdb name order and have a field call suppl_no what did I miss...
Please help again...
Sheley
[This message has been edited by Sheley (edited 06-26-1999).]
-
Should your sql statement be
"Select * from order where suppl_no = '" & text1.text & "'"
Hope this helps.
Bash
