S
Stephanie Trentham
I am creating a form through Front Page which dumps information into Access.
I have the form dumping into a table called "Results". One of the fields in
the form is called "WorkshopDate" which contains 4 dates. I need to restrict
the number of signups for each of the 4 dates to 28. I have read over some of
the help documentation and I think I need to use the Dcount function along
with one other function, but I am having trouble with putting the two
funcitons together and getting them to run automatically. When the user hits
the 'submit' button, I need it to either go to a page that tells them to
choose another date or add it into the Java Script to give a promt to choose
another date. Any suggestions would be appreciated.
I have the form dumping into a table called "Results". One of the fields in
the form is called "WorkshopDate" which contains 4 dates. I need to restrict
the number of signups for each of the 4 dates to 28. I have read over some of
the help documentation and I think I need to use the Dcount function along
with one other function, but I am having trouble with putting the two
funcitons together and getting them to run automatically. When the user hits
the 'submit' button, I need it to either go to a page that tells them to
choose another date or add it into the Java Script to give a promt to choose
another date. Any suggestions would be appreciated.