need help with this filter..

smoke

Registered User.
Local time
Today, 00:18
Joined
Sep 2, 2004
Messages
18
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
 

Users who are viewing this thread

Back
Top Bottom