need code for form

[Dean]

I need to make a form for a vacation system we want people
to sign up for their vac on it but we want to limit the
number so after a certain number is reached on a certain
day, we like it to stop accepting vacation on the full
days,....any ideas on the code?


Thanks
Dean

 

[Neil]

Dean,

If you create a normal table and form with all the fields you need. You
could code the before insert event for a form to count how many existing
records there are for a certain day and then stop the record from being
added if it exceeds your limit (how u specify your limit depends on how the
limit is worked out...). The DCount function would be usefull for this type
of thing...

HTH,

Neil.