We set up a form in Front Page which the students will fill out for career day. We will have 6 different sessions in which different classes will go to the web page to enter their choices. This information will then filter back to an Access database. What I need help with is, for example, for the career of Doctor, we only want 20 students to be able choose it per session. Then, for the 21st student, we want a message to pop up saying something like "You must choose another career. The limit for this choice have been reached". My question is, how do I set up the limit for each choice the students will choose?
Any help you may give me will be greatly appreciated.