Hi
I have a search form with a ComboBox to search a query called CustomerName (cboCustomerName)
I also have a "Search" button that opens the report that is linked to the query.
I can select the CustomerName in the ComboBox but when I click on the "Search" button the report opens up blank....no data, only the fields of the report.
I tested the form by using a Text Box and that works like a dream. Why is my ComboBox not working as this would greatly simplyfy the process and remove margin of data entry errors.
This is my SQL statement for the query;
SELECT tblCustomer.CustomerName, tblCustomer.ContactName, tblComsFeedback.ComDate, tblAccount.InvoiceNumber, tblComsFeedback.Feedback, tblAccount.FinishDate, tblAccount.InvoiceAmount
FROM tblCustomer INNER JOIN (tblAccount INNER JOIN tblComsFeedback ON tblAccount.AccountID_Pk = tblComsFeedback.AccountID_Fk) ON tblCustomer.CustomerID_Pk = tblComsFeedback.CustomerID_Fk
WHERE (((tblCustomer.CustomerName)=[Forms]![frmComsFeedbackAll]![txtCustomer]) AND ((tblAccount.FinishDate) Is Null))
ORDER BY tblAccount.InvoiceNumber;
This is my ComboBox Row Scource;
SELECT [tblCustomer].[CustomerID_Pk], [tblCustomer].[CustomerName] FROM tblCustomer;
My ComboBox is unbound, as is my Text Box. I have searched for a solution online but am unable to find one.
Please help.