adodc error

[Sheley]

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).]

[bashfirst]

Should your sql statement be
"Select * from order where suppl_no = '" & text1.text & "'"

Hope this helps.

Bash