Filtering RecordSource through VBA in MS Access Forms

Sleepy

I'm trying to filter the recordset shown in an MS Access Database form when the value of an unbound combo box is changed. I'm not getting any errors when I test it but the recordset displayed isn't changing at all.

Can anyone see what I'm doing wrong here?

Private Sub SelectBranch_Change()
    Dim strFilter As String
    strFilter = "SortCode = '" & SelectBranch.Value & "'"
    Form.Filter = strFilter
    Form.Refresh
End Sub

Seth Brundle

Private Sub SelectBranch_Change()
    Dim strFilter As String
    strFilter = "SortCode = '" & SelectBranch.Value & "'"
    Form.Filter = strFilter
    Form.Filteron = true
    Form.Refresh
End Sub

Sleepy

Cheers kbannon. Works like a dream.

Seth Brundle

no problem
just stick the cheque in the post!