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!

Its probably your "Adodc1" control. Is it on the form where your code is? What event is this code in?

Whats this ?

Code:

---

'" & Company_Projects.pro_no & "'"

---

is Company_Projects a class or class object?


:wave:

Its a table and good spot as its not wrapped in the double quotes.

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?