Combo box Restrictions

[rfurb002]

limit number of values in table

Background:
I'm doing a database for a camp
They can only have 96 children for any given week of camp
I have a combo box that the data entry clerk uses to assign weeks (1, 2, 3, etc)

Question:
Is it possible to make it so that I can limit how many entries (campers) are selected to attend a week of camp? So that only 96 entries can have week 3 selected?


Hope this makes sense!

Ron

 

[RuralGuy]

DCount() will return the count of how many already have week 3 selected. Look in VBA help for the syntax for the DCount() function and you can use in in the BeforeUpdate event of the ComboBox.

 

[RuralGuy]

I just realized this is posted in the Table section. I hope you are not using LookUp fields! The Evils of Lookup Fields in Tables Putting them on FORMS is just fine.