LIKE question in a combo box

[molly]

I have an Unbound combo box used to look up a formula's prod family Name. I can type in a name EG Chili. and i will see things that say Chili. But when i mouse click on one item, nothing happens. No record is selected. And there are records.

i have the following command on the After Update line:

Private Sub CboProductFamilyNameFilter_AfterUpdate()

DoCmd.ApplyFilter , "[ProductFamilyName] Like '*" & Forms![7002frmNSBulkMain]![CboProductFamilyNameFilter] & "*'"
Me.CboProductFamilyNameFilter = Null

End Sub

I am trying to type part of the product families name EG CHILI and then see all my possible chili choices. The word Chili may be at the front or maybe in the middle of the name like Chili Dog or Red Chili. I would like to see anything with the word Chili.

Can you help me on this After Update?


FYI, My Row Source line is:

SELECT DISTINCT tblNSBulkMain.ProductFamilyName, tblNSBulkMain.ProductFamilyID FROM tblNSBulkMain GROUP BY tblNSBulkMain.ProductFamilyName, tblNSBulkMain.ProductFamilyID ORDER BY tblNSBulkMain.ProductFamilyName;

regards,
Molly

 

[molly]

I also notice that if my product family name has a # sign, the after update will not get that record.

eg if I have ... Chili #123


molly