adodc error

[Sheley]

Hi Friend

There must have something I missed.... 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).]

[vikram.k]

Hi Sheley,

I think you have set the RecordSource value at properties window itself. So it gives an error at compile time like "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....".

So set the recordsource property value
in your form_load event.

Private Sub Form_Load()

Data1.RecordSource = "select *from order where suppl_no = '" & text1.text & "'"

End Sub

Bye!..


------------------