SELECT * FROM tblHOUSES WHERE tblHOUSES.Bedrooms = #Form.noofbedrooms# Untitled Document

#Recordset1.HouseCode#