Full Version: Filter A Continuus Form
UtterAccess Forums > Microsoft® Access > Access Forms
mike60smart
Hi Everyone
I have a Form named "frmCommitteeMembers" set as a Continuous Form
The first Control on the Form is a Combobox that allows me to select a Committee Type, this is named "cboCommittee"
The data displayed would be like this:-
Committee Post Duration
Council Chairman 2
Council Secretary 2
Council Treasurer 2
Clyde Branch Chairman 2
Lothian Branch Chairman 2
What i want to be able to do is place a Combobox in the Header that would allow me to select a Committee Type and ONLY
display the Committee Records available
So if I select Council using the Combobox then only these records would be displayed:-
Committee Post Duration
Council Chairman 2
Council Secretary 2
Council Treasurer 2
Is this possible??
Your help appreciated
J.D.
Hi Mike,
Try Using Multiple combo boxes to filter a form from the UA Code archive to see if that gives you the examples you need.
Hope this helps,
J.D.
Here is Candace Trips combo filter demo as well. it's an oldie but gives you multiple examples depending on the approach you want to take.
mike60smart
Hi JD
Could I apply the Code to the After Update of my Combobox in the Header section of the Form?
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.