Limit number of records submitted to Access from FrontPage form

S

Stephanie Trentham

I have a form created in FrontPage which dumps information into an Access
Database. One field "WorkshopDate" is a list box with 4 option dates. I need
to limit the number of 'signups' per date to 28. Any suggestions I could get
on this would be appreciated.
 
K

KARL DEWEY

Use a WorkshopDate field and Signups number field combination as your key.
In your table set the Validation rule for the number field to <29.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Limiting number of records 0
How do I clear a form? 0
Page numbering with Merged Document and IF statements 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Pause VB Code 1
filtering a form based on the values of a subform 0
Need to Count by two different criteria in same Totals query 4

Top