Need help dynamically filtering subforms so I can re-use them.
Posted on 2007-11-29
Probably easy for an Access Whiz, but I just don't get it.
I wish to use the SAME subform twice on a main form, but wish the results they display to be different. I want to do this so I do not have to design two subforms which are identical apart from the results they display.
For example, [subform1] will show items from my orders table that are ordered, [subform2] will show items from my orders table that are not ordered. The "Source Object" for both of these forms are set to the same: [frmPurchaseOrderListSubform]
How do I achieve this?