Access - Limiting Records

[SantasLittleHelper]

I currently have a field which has a drop-down of groups which can be assigned to the client (record)

Is it possible to limit the number of people who are assigned to a group?

E.g.
10 Records to Group 1
10 Records to Group 2 etc..

If this is possible, is it also possible to create a validation / pop-up to tell the user that the group is full?

 

[xenou]

You might want your drop down to include only groups with nine or less. Or have a two column list in it:
Group 1 | Full
Group 2 | Available
Group 3 | Available

you can also use a form before update event to validate the number of people assigned to a group before making the updates/insertions.

 

[SantasLittleHelper]

Thanks for replying. I'm not very good with Access so how would I go about having a 2 columned list? - Presuming the availability can be updated

 

[stumac]

Here is a link to a basic example:

https://app.box.com/s/iwdthe0x77xencgyxkljphvwqcwka3v6

I have used a query as the source for the combo box and put basic code in the before update event to prompt the user if they try to select a full group.

 

[xenou]

More info on comboboxes here:
https://fisher.osu.edu/~muhanna.1/837/MSAccess/tutorials/combo.pdf

Note that after updating the table the combobox data source would need to be refreshed (as one of the groups will now have a new total since a person has been added to a group - if further entries will be made)

 

[stumac]

Nice resource on combo boxes!

In my sample I have a combo box requery fire on the oncurrent event.