MS Access: implementing Form Filtering on a Subform Based on a Combo Box Selection
I'm sure I'm missing something obvious here, but I'm stuck trying to I'm experiencing issues with filtering records in a subform based on the selection made in a combo box on the main form in MS Access 2019..... The main form is bound to a table called `MainTable`, and the subform is bound to a query that pulls data from another table called `DetailTable`. I've set up the combo box (`cboFilter`) to allow users to select a category from a list, and I want the subform to display records that match the selected category. However, when I select an item from the combo box, the subform does not refresh to show the relevant data. Here’s the code I currently have in the combo box's `AfterUpdate` event: ```vba Private Sub cboFilter_AfterUpdate() Me!SubformControlName.Requery Me!SubformControlName.Form.Filter = "CategoryID = " & Me.cboFilter Me!SubformControlName.Form.FilterOn = True End Sub ``` I’ve checked that `CategoryID` is the correct field name in `DetailTable`, and I confirmed that the combo box is correctly bound to the appropriate field. However, when I run the code, I get an behavior that says "Type mismatch". I’ve tried explicitly converting the filter expression using `CStr(Me.cboFilter)` and `CLng(Me.cboFilter)`, but the behavior continues, and the subform still doesn't show the filtered results. I also verified that there are records in `DetailTable` that correspond to the selected category. What could be causing this scenario, and how can I correctly filter the subform based on the combo box selection? Are there best practices I should consider when dealing with filtering subforms in MS Access? This is part of a larger service I'm building. What's the best practice here? I'm on Linux using the latest version of Vba. I'm working in a Windows 10 environment.