Locking form

[MMacPherson]

I need help! The company I work for has designed a database with a form that
you fill out and submit. The form is open to all employees, but for each
session that they can choose, there is a limit to the number of people who
can sign up. Apparently, they cannot follow directions because they always
sign up more people than are allowed in each session. Is there a way to lock
the form for the sessions that are full? If I am not explaining myself very
well, please let me know.

Thanks!

 

[Klatuu]

Your question doesn't include any information on how you determine how many
people can be signed up for a session or how you know how many people have
signed up, but basically, you can use the Form's Current event to test for a
full session and set the form's Allow Edits property to false when the limit
is reached.

 

[MMacPherson]

I determine how many people can be signed up for a session and I inform the
employees by email and by noting it on the form. So, when they open the sign
up, it is at the top of the sign up. I know how may people have signup up by
opening the dt table. Does that help? What happens is I will go into the dt
table to check on how many people have signed up and I will find there are
more than I have allowed openings for. I want to figure out a way to lock
the form, so say when I tell them 10 people are allowed to sign up, that
after 10 have been signed up it will no longer let them submit a sign up form.

 

[Klatuu]

OK, my original post will do what you want. You just need to make the
determination and if the maximum number of people have signed up, set the
Allow Edits to False; otherwise, set it to True.