I have a simple filter set up to filter the subform products by
category ID. It is the same as a filter in a different form other than
it gives me the error: runtime error 2001 you cancelled the previous
operation. Here is my code. The subform is Products, and the combo
box the filter is based on is CatSel.
Private Sub CatSel_AfterUpdate()
Products.Visible = True
Products.Form.Filter = "[Products].[CategoryID]= '" &
Forms!ProdCat.CatSel.Column(1) & "'"
Products.Form.FilterOn = True
End Sub
Private Sub Form_Load()
Products.Visible = False
Products.Form.FilterOn = False
End Sub
Thanks
~Chad
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
