kindly check the syntax..
hold = variable here..
Adodc1.RecordSource = "SELECT Company_Profile.contact_fname AS contact_fname,Company_Profile.contact_middle AS contact_middle,Company_Profile.contact_lname AS contact_lname, Project_Info.title AS title, Project_Info.pro_no as pro_no, Company_Projects.pro_no as pro_no1 FROM Company_Projects, Company_Profile, Project_Info WHERE Project_Info.title ='" & hold & "' and Project_Info.pro_no = '" & Company_Projects.pro_no & "'"
Adodc1.Refresh
The error is object required.
Please help me!
Re: kindly check the syntax..
Its probably your "Adodc1" control. Is it on the form where your code is? What event is this code in?
Re: kindly check the syntax..
Whats this ?
Code:
'" & Company_Projects.pro_no & "'"
is Company_Projects a class or class object?
:wave:
Re: kindly check the syntax..
Its a table and good spot as its not wrapped in the double quotes.
Re: kindly check the syntax..
You are missing the control's name somewhere in your code. Can you post your part of the source code within this thread. Because so we can have a good look at it.
Moment please: Has your object been placed as a control on your Form?