Show a Decreasing Number in a Listbox as Information is Added

[padlocked17]

I am looking for suggestions on how to accomplish this:

Brief Overview:
The database allows me to assign x number of people to a task. The task is built specifying a certain number of people with special qualifications.

I then have a list of all our personnel with a column dealing with their qualification.

I'm attmepting to have a form show the number of people from each qualification with a combo box that allows me to add people based on those qualifications. When I add a person with a specific qualification, I would like for the number required to appear as one less, so at a glance, you can determine if anyone else is needed to be added to the task.

I am currently showing the number of people needed for a task in a listbox and am also showing the people assigned in a listbox and have a filterable combo box that allows me to select people based on the needs of the task.

Any ideas on how to accomplish this?

 

[vbaInet]

For your first attempt look into the DCount() function. Then you can also use the combo box's ListCount method as well. Use a combination of both in a textbox's control source.

The idea is to remove that person from the combobox after adding.

If you don't want to remove from the combobox, then you need two lots of DCounts.

Here's a good link:

http://www.techonthenet.com/access/functions/domain/dcount.php