rsburge
asked on
Remove Selected Values from Access Combobox
I am working on a donations/sponsor database for a non-profit I volunteer for. We have a form with a combo box that lists all of the sponsorship options available.
We would like to have certain values removed or greyed out if they have already been selected for this years event.
So, for all of the records with
1. matching values in the Event field
2. And the Campaign ID (bound column of Campaign combo box) is not 12 or 13 or between 36 and 44
3. When a campaign is selected, remove it from the list, or grey it out. This is to prevent them from being used again.
Is this possible?
We would like to have certain values removed or greyed out if they have already been selected for this years event.
So, for all of the records with
1. matching values in the Event field
2. And the Campaign ID (bound column of Campaign combo box) is not 12 or 13 or between 36 and 44
3. When a campaign is selected, remove it from the list, or grey it out. This is to prevent them from being used again.
Is this possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I inherited this database with the following table structure...
Events table that holds the different events; usually 2 per year, this is more of a lookup type of table
Donations table that holds all of the donation records
Campaigns table that holds the different sponsorships that are offered; this is a lookup type of table
Contributors table that holds the list of different sponsors; this is a lookup type of table
How do I create the query to look for records with the same event, and then filter the campaigns combo box where the campaign ID is not 12 or 13 and not between 36-44, and it is not already selected?
I would think I maybe need a temp table for the records from the donations table with the same event, and then query the temp table for the combo box source, but I really have no idea how to do that.