I Have a combobox the has a list of companies (SelectCallcb). I have the following SQL:
In the where clause, the term [Enter Call Company], needs to be replaced with the company name that was selected in the combobox. Still new at this, tried to find but no joy.
Code:
SELECT Suspects.[First Name], Suspects.[Last Name], Suspects.Title, Suspects.Address, Suspects.Company, Suspects.CallCompany, Suspects.City, Suspects.zip, Mastertbl3.callingnumber, Mastertbl3.calldate, Mastertbl3.starttime, Mastertbl3.ActionableFlag
FROM Mastertbl3 INNER JOIN Suspects ON Mastertbl3.companyname1 = Suspects.CallCompany
WHERE (((Suspects.CallCompany)=[Enter Call Company])
ORDER BY Mastertbl3.calldate;
In the where clause, the term [Enter Call Company], needs to be replaced with the company name that was selected in the combobox. Still new at this, tried to find but no joy.