Error referencing filter property of a sub-form container

[GraeagleBill]

I have a form where the code-sheet sets a filter for the RecordSource of a sub-form. Below is a screen-shot of the code when debug is entered. I hovered over the variable that contains the filter expression. (cmboRetreats_Click() is called by the OnOpen event code, as opposed to a click action.)





And, a screen-shot of the error:



The error DOES NOT suggest a problem with the sub-form's RecordSource query, which I ran directly without errors.

The offending statement: "Me.TransAcctSubform.Form.Filter = SubFrmFilter" is making reference to the sub-form's container control, "TransAcctSubform". I'm clueless at this point what is giving rise to the error.

Any ideas?

Thanks,
Bill

[Xipooo]

Try moving your function call to the "On Load" event.

A recordset is not bound to the form yet during the On Open event. It is during the loading of the form that the recordset gets bound.

[GraeagleBill]

The error goes away, but only the parent form's header displays. I.e., the parent form's Detail section displays empty.

[Xipooo]

It must be because your filter string is causing 0 records to be displayed. Evaluate what the filter requirements are and whether or not your recordset will have any records that match the criteria at the point where the form loads. It looks like your filter is based on what someone selects in the ComboBox. Since the user hasn't had a chance to select something yet, your combobox will likely have a "Null" value. So your filter is looking for recordsets that have a "Null" for FolioID.

Do you have a default value for your combobox?

[GraeagleBill]

I stumbled upon the problem. Even though this code has been running successfully for years with a different back-end mdb, it seems that the current back-end has "tickled" a problem that has existed since the app was written many years ago. Some how, the parent form had its RecordSource bound to the same query as the sub-form in question here. The parent ought not have ANY RecordSource at all, as all the data to be displayed is via the sub-form. Apparently, the duplication caused problems when the current back-end (new) only has one record in its RecordSource, namely that relating to the folio "FH-AccNo".

Thanks for your thoughts,
Bill