hi, im trying to apply a fitler to a form and a subform with 1 combo box, here is my code, the subform seems to filter fine but my main form always has problems ive tried combinations of different ways to do it but hopefully someone here can help me out thanks a bunch.
Private Sub frmWHSEGroup_AfterUpdate()
WAREHOUSE_listview.Form.RecordSource = "SELECT * from master_inventory where [tblinvgr_flag] = frmwhsegroup"
Me.Filter = "tblinvgr_flag =" & frmWHSEGroup
Me.FilterOn = True
Me.Requery
End Sub
Private Sub frmWHSEGroup_AfterUpdate()
WAREHOUSE_listview.Form.RecordSource = "SELECT * from master_inventory where [tblinvgr_flag] = frmwhsegroup"
Me.Filter = "tblinvgr_flag =" & frmWHSEGroup
Me.FilterOn = True
Me.Requery
End Sub