Link to home
Start Free TrialLog in
Avatar of rsburge
rsburgeFlag for United States of America

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?
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rsburge

ASKER

Yes, I have an Events table and the Event field on the form is bound to the Event ID field of the Events table.

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.