File Continually Crashes - Possible VBA Issues?

[kazaccess]

I have a main form that houses a subform. If I click a value in the subform, it will filter the main form to that value. However, my Access has been crashing (starting today) when I perform this action, and I'm thinking it may possibly related to the VBA I have performing this filter action. See my code below. This was working without issue the last few days, but today it began crashing without any updates to my code at all.

Dim strFilter As String    On Error GoTo ErrHandler
    'If the clicked text box has a value, then filter my main form to the record matching the clicked value
    If Forms![Load Planning]![DailyFile subform].Form!Text14.Text <> "" Then
        strFilter = "[Order Line Key] Like '*" & Forms![Load Planning]![DailyFile subform].Form!Text14.Text & "*'"
        Forms![Load Planning].Filter = strFilter
        Forms![Load Planning].FilterOn = True
    Else
        Forms![Load Planning].Filter = ""
        Forms![Load Planning].FilterOn = False
    End If
    Exit Sub
ErrHandler:
    MsgBox Err.Description, vbExclamation


    DoCmd.SetWarnings (WarningsOn)

By crashing, I mean that I get the popup telling me to search for a solution online or restart Access. No other error messages appear.

[June7]

It is unusual to have a subform dictate to the main form. Why are you doing this? What is the relationship of main and sub forms?

[kazaccess]

When the subform value is clicked, the main form will be filtered to that value so that the user can update/add items to that record from the main form. The subform is a different table/query than my main form.

[June7]

Sorry, that doesn't make sense. In a conventional form/subform arrangement where the datasets have a dependent relationship, the main form dictates which related records show on the subform. Are Master/Child Link properties set?

[kazaccess]

Sorry, I could have been clearer. No, I do not have master-child relationships set up. Both tables used here have the same primary key, but it is possible for both tables to have different records (they are not joined). Therefore, my subform acts as a lookup. When that primary key value is clicked, it will look up that value in my main form and display its contents.

[June7]

So both forms have the same data source? A combobox or listbox is more commonly used for selection of filter criteria. Review http://www.allenbrowne.com/ser-62.html

Perhaps you should look at the Split form object.