'Like' Query Question

[ihoskins]

I am trying to make a query that will prompt for the variable and then search the fields for that variable. I was thinking something like this...

SELECT tbl_Facility.FacilityID, tbl_Facility.HouseName, tbl_Facility.Address1
FROM tbl_Facility
WHERE (((tbl_Facility.Address1) Like "*[Search]*"));


I need the query to prompt for input. Any ideas?

Thanks
Ian

 

[ihoskins]

Duh me!!!

SELECT tbl_Facility.FacilityID, tbl_Facility.HouseName, tbl_Facility.Address1
FROM tbl_Facility
WHERE (((tbl_Facility.Address1) Like "*" & [Search] & "*"));