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!