AbacusInfoTech
asked on
Need help dynamically filtering subforms so I can re-use them.
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: [frmPurchaseOrderListSubfo rm]
How do I achieve this?
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: [frmPurchaseOrderListSubfo
How do I achieve this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I should add that as far as I know you have to do the recordsource settings via code. I don't believe there is any way to do it via the UI.
ASKER
Yep, exactly what I needed. Thanks...
ASKER