Query using a combo box

[indesisiv]

Help!!
I have just created a query and it doesn't work.
Basically to give you the background...

I have a text box with things seperated by commas.
I would like to run a search using a combobox on a search form. That side is fine the problem is that i can't get the query to work.

It looks like this
SELECT units.Services1
FROM units
WHERE (((units.Services1) Like '*[Forms]![frmSearch]![cboSearching]*'));

But for some reason that doesn't work.
Anybody got any idea why it doesn't work!!!

Thanks for any help.
Steve

 

[Mile-O]

SELECT units.Services1
FROM units
WHERE (((units.Services1) Like "*" & [Forms]![frmSearch]![cboSearching] & "*"));

 

[indesisiv]

Thank you

Cheers Mile-O-Phile
knew that it was something daft.