ComboBox does not work on a Search Form

[PeterS]

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.

[CJ_London]

you are comparing chalk and cheese. Your combo is bound to the ID field, but you are trying to match on name

modify your WHERE line

WHERE (((tblCustomer.CustomerID_Pk)=[Forms]![frmComsFeedbackAll]![txtCustomer]) AND ((tblAccount.FinishDate) Is Null))

I'm assuming txtCustomer is the name of your combo - if it isn't change the name in your query to the name of your combo

[PeterS]

Thank you very much. I acctually figured it out about 3 min after I posted