vickiwells
Registered User.
- Local time
- Today, 08:10
- Joined
- Jun 30, 2000
- Messages
- 61
I found this question while searching on another forum, and since it states my problem exactly, I'll just copy it:
Has anyone come up with a GENERIC way of providing filtering of subforms?
For example, in the Northwind database, the Orders form has an Orders detail subform.
If you want to filter for only records that contain a particular product on the subform, Access does not apply the appropriate filtering on the main form, such that your main form always contains the entire record set, thus rendering filtering of subforms completely useless.
If you have a large database with many subforms, including nested subforms, there's no practical way, that I know of, to provide the end user with the same "filter by selection" functionality that Access provides in a single form environment.
I was hoping someone may have or know of an add-in that would provide RIGHT Click FilterbySelection access to subforms, such that it would adjust the recordsources appropriately to limit the main form to only those records that contain the items on the subform. (The same way that it functions in a single form environment).
I find this to be a very limiting omission on Microsoft's part and makes it difficult for the end user to find information when subforms are used.
Do you have any suggestions or knowledge of any existing add-ins or utilities that would provide this subform filtering capability?
Has anyone come up with a GENERIC way of providing filtering of subforms?
For example, in the Northwind database, the Orders form has an Orders detail subform.
If you want to filter for only records that contain a particular product on the subform, Access does not apply the appropriate filtering on the main form, such that your main form always contains the entire record set, thus rendering filtering of subforms completely useless.
If you have a large database with many subforms, including nested subforms, there's no practical way, that I know of, to provide the end user with the same "filter by selection" functionality that Access provides in a single form environment.
I was hoping someone may have or know of an add-in that would provide RIGHT Click FilterbySelection access to subforms, such that it would adjust the recordsources appropriately to limit the main form to only those records that contain the items on the subform. (The same way that it functions in a single form environment).
I find this to be a very limiting omission on Microsoft's part and makes it difficult for the end user to find information when subforms are used.
Do you have any suggestions or knowledge of any existing add-ins or utilities that would provide this subform filtering capability?