Using an Option group selection to filter subform

[Dave Hickman]

I have an option group, that I placed in the Forms header, containing all of
the possible locations for devices. I then have a subform, in the Detail
section, that I would like to display all of the devices that are in the
location selected in the Option Group selected in teh header. Is this
something that is possible to do. Essentially I just need to capture the
Option value and use it to filter the subform, but cannot seem to get it
working. Any help is greatly appreciated.
Dave

 

[Al Campagna]

Dave,
I would suggest a combo box instead. Option Groups deliver numeric
values, which could be a bit clumsy when translating to a Parent/Child
relationship to your subform.

For example... equipment in a Department. (cboDepartment)
Then the cboDepartment value selected would directly define the
Parent/Child (cboDepartment to Department in the subform).
If a new Department is created, just add that to your combo... no need
to add another option in the OptionGroup, and translate some numeric value
to a text value for linking.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."