Access Filter in SubForm

Murray Brown
Murray Brown used Ask the Experts™
on
Hi

I have a sub form that needs to filter data based on a label in my main form. The label contains a key value
How and where would I do this?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
Labels are the names of things.  They don't contain data.  How is the data getting into the label?
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
there is a field called ArmPK on the main form that it gets its data from. Thanks for pointing this out
Ryan ChongSoftware Team Lead

Commented:
In Access, you can use the subform wizard (by dragging the table to your form design) to complete that.

Untitled.jpg29163801.accdb
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks Ryan but the subform already exists
Software Team Lead
Commented:
but the subform already exists

Ok, so you need to re-configure your subform accordingly.

Go to the Subform's Properties, and setup the link fields

Untitled.jpg
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks very much

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial