Like clause used in query builder

[Fuzuy]

Hi,

a combo box value is used to a pop-up new open Form. Where in that
form a list box row source used that combo box value in query builder
as a creteria using LIKE Clause and is not working, anyone can point
out what should be a correct way to do it?

LIKE "*###*" -->where ### is the combo box value of an existing open
Form

SELECT dshet_apr.Number, dshet_apr.Title_Description
FROM dshet_apr INNER JOIN datasheet_d ON dshet_apr.Number =
datasheet_d.Number
WHERE (((dshet_apr.Title_Description) Like "* [Forms]![frmm]![combo1]
*") AND ((datasheet_d.Dis)=[Forms]![frmm]![combo46]));


Thanks for help.

 

[Douglas J. Steele]

WHERE (((dshet_apr.Title_Description) Like "*" & [Forms]![frmm]![combo1] &
"*") AND ((datasheet_d.Dis)=[Forms]![frmm]![combo46]));