I have form with a few search text boxes on. Also on the form is a sub form (frm_Contacts_Sub) which is a contiuous form with tbl_contacts as it record source. I have used a continuous form instead of a list box as i need to allow the user to select a contact using a tick box on each record.
My question is how do i filter the sub form from my text boxes from the main form. I have some code which i am using however, when i begin typing in the search text box is always returns the same one result regardless what i type.
Private Sub SearchText_Change()
Dim SQL As String
SQL = " SELECT * FROM tbl_Contacts Where [company_name] Like '*" & Me.SearchText.Text & "*'"
Me![frm_contacts_sub].Form.RecordSource = SQL