Limit number of records submitted to Access from FrontPage form

G

Guest

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.
 
G

Guest

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

Searching/Filtering Form by Date Calendar: Week Beginning... 1
Need to Count by two different criteria in same Totals query 4
Limit Sub Form records based on Main Form 1
Limit to List 1
I do i limit the size of a form in Access 2007? 1
Data of many records of 1 form to populate another form via Cmd bu 1
limit a continous form to 10 rows/records? 4
Data of many records of 1 form to populate another form via Cmd bu 2

Top