Verify the Number of Players Selected (1 Viewer)

[henryihunter1954]

Hello:

I have a form that has a listing of players.
I also have a check box by each name. The entry person will select 4 players.

I want the program to verify the number of players that were selected.
If the number of players is not 4, I want to notify the entry person and retry.

Thank you all for all the assistance that I've gotten. I've used the suggestions before and works better than what I've done so thanks for all help.

 

[bob fitz]

If the check box is bound to a field in the table you could use DCount() function to count the selected check boxes. Alternatively you could put a text box in the forms footer section and use Count in that.

 

[henryihunter1954]

Thank you Bob. I'm going to give it a try right now.

All of this is very helpful.