I'm currently using Access 2003, and the problem that I'm running into is that when I attempt to use the autoupdate command in the code snippet below, my subform says its 'Filtered', but nothing appears in the sub form. I think the problem may lie in the fact that my combo box cboItemNum2 is actually pulling all of its values from our server SQL database, where the subform is gathering data from a local Access database. Reason being, we're attempting to create a bill of materials inventory, and all of the parts are entered into one form, going to table 'tblBOMParts'. Another form is meant to view all of these entered parts (called frmTestView). Two combo boxes filter all known parts from our SQL database (first combo box selects all available classes, and once 'Class' is selected, then all of the parts for that class are displayed in the second combo box). I want this second combo box, which is unbounded, to query the table tblBOMParts, and filter all of parts to equal the selection in the 2nd combo box. Is there a parent-child relationship that I'm missing here? When I first open frmTestView, a couple parts show up on the subform, even though nothing is selected. I am really confused, and I don't know what's causing those couple parts to show up, and even more so, why nothing shows up when I make a selection.
Private Sub cboItemNum2_AfterUpDate()
Me.sfmViewPart.Form.Filter = "BOMPartNum='" & Me.cboItemNum2 & "'"
Me.sfmViewPart.Form.FilterOn = True