Trying to filter a continuous form using an unbound combo box that is set with a value list
when the value changes I was hoping to filter the form to only show the blank records
any suggestions?Code:Private Sub Text53_AfterUpdate() If Me.Text53.RowSource = "Name" Then Me.Filter = "SchoolName is null" Me.FilterOn = True ElseIf Me.Text53.RowSource = "Suburb" Then Me.Filter = "SchoolSuburb is null" Me.FilterOn = True End If End Sub