Limit data entries on forms

[Guest]

Hello! Thanks for your help in advance. I created a sign-up sheet (form) in
access and want to limit the number of people who can sign up on the sheet to
four records. My table is very simple: last name, first name, major,
current status. I have created a form allow data entry, but I would like the
record limit to be four. Can you tell me how to do this?

 

[John Vinson]

Hello! Thanks for your help in advance. I created a sign-up sheet (form) in
access and want to limit the number of people who can sign up on the sheet to
four records. My table is very simple: last name, first name, major,
current status. I have created a form allow data entry, but I would like the
record limit to be four. Can you tell me how to do this?

What's your table structure? Data is, of course, stored in tables -
not in forms. Do you want a maximum of four records in your table,
ever?

You can put code in the Form's BeforeInsert event to count records and
cancel the insertion if there are already four - but I'm really
concerned that you may be jumping to form design too early, if your
table structure isn't yet properly normalized!

John W. Vinson[MVP]