SYNTAX ERROR IN FROM CLAUSE

[bobm104]

I have a VB application which starts with a dialog box message: SYNTAX ERROR IN FROM CLAUSE each time the project is run. The only option in the box is OK. When OK is hit the application runs as normal.

Any idea of the cause of this? - Bob

[Dim]

You're probably gonna have to post the code that you are using. But what i would probably do is comment out parts of the code until the error no longer comes up and then look over that code.

Gl,
D!m

[P.S.W.]

Sounds like a SQL query is malfunctioning somewhere.

[bobm104]

Thanks for the posts - I found the problem. It was tied to an adodc object. This project used 2 adodc objects pointing to different tables in the same access db. The error seems to be related to a recordsource not being set on one of these objects. I set the cmdType to adCmdTable and the RecordSource to the table and that solved the problem. The RecordSource had been set in code before - on both of these objects - so I'm not sure why one of them had this problem.