I have this bit of code -

rstScopeQuery.Open "SELECT line_data_id FORM section_detail", _
cnnLocal, , adLockOptimistic

and it bring on a "syntax error (missing operator) in query expression..." at run time.

I am sure that the answers is right in there but I can't see it.

Any ideas ?

Hi os1,

that looks like ADO which i don't know much about, but if you pasted that from code then you need to change FORM to FROM

best wishes

Anke

Thanks - I think a bit of sleep would have help find that type O