Subform that filters on combination of 2 combo boxes

[heinensk23]

I have a form that uses cascading combo boxes to filter on a subform.
Menu Group is the first box and Menu Item choices are based on what is chosen in Menu Group.
However, there are some menu items that show up in multiple Menu Groups.

Right now the subform only filters on the Menu Item.
I need it to filter on both Menu Group field and Menu Item field.

Here is the code:

Private Sub casc_cmbo_BRASS_Menu_Group_AfterUpdate()


Me!casc_cmbo_BRASS_Menu_Item.RowSource = Me!casc_cmbo_BRASS_Menu_Item.RowSource
Me!casc_cmbo_BRASS_Menu_Item = Null


End Sub


Private Sub casc_cmbo_BRASS_Menu_Item_AfterUpdate()


Dim myCascmenuitem As String
myCascmenuitem = "Select * from tbl_BRASS_Item_Setup where [Menu_Item_Toast_Name] = '" & Me.casc_cmbo_BRASS_Menu_Item & "'"
Me.subfrm_BRASS_ITEM_SETUP_subform.Form.RecordSour ce = myCascmenuitem


Me.subfrm_BRASS_ITEM_SETUP_subform.Form.Requery


End Sub

[Bob Fitz]

Try:

Dim myCascmenuitem As String
   myCascmenuitem = "Select * from tbl_BRASS_Item_Setup where [Menu_Item_Toast_Name] = '" & Me.casc_cmbo_BRASS_Menu_Item & "' AND [SecondFieldName] = '" & Me.NameOfSecondCombo & "'"
   Me.subfrm_BRASS_ITEM_SETUP_subform.Form.RecordSour ce = myCascmenuitem
   Me.subfrm_BRASS_ITEM_SETUP_subform.Form.Requery

Substitute your real names for those shown in blue.