Error code :invalid sql statement expected 'delete' 'insert'"...

[Starter]

I am getting the above error message when using the following code in access 2010



Rs1.Open "", Cost, adOpenForwardOnly, adLockReadOnly

Rs2.Open "Stock", cn, adOpenDynamic, adLockOptimistic

your help will be greatly appreciated.

[orange]

I suggest you read this and do some testing.

I'm also going to recommend working through this tutorial to get a firmer grip on design concepts.

anddon't overlook Google to find info.

Good luck.

[Starter]

is there anything in that line of code i need to check. It works fine with access 2003