Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Syntax Error in FROM Clause

Status
Not open for further replies.

kysterathome

Technical User
Dec 22, 2004
37
LU
Hey all,

I am getting an error message in one of my forms:

Syntax Error in FROM clause

But I am not using any FROM in the VBA of that form at all?!

Any idea?

Kysterathome
 
I should of course add that I can't even enter the form in Form view because of that error.

Kysterathome
 
Seems that some control is bound to a query/table that no longer exists

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Also, you may want to check the RowSources for combo and list boxes.
 
Indeed, the problem was in the Record Source of the parent form... I wonder what I did to upset it...

Thanks a lot both of you! One worry less.

Kysterathome
 
Name changes or deletions to tables, queries and / or fields....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top