how to restrict # of records in a table

[ahvc]

Hello all,
I hope this is a right place to ask this:

I have a small application. I was asked if I can just make sure i can restrict the # of records in a few tables. For example, just max of 5 records in the member table. If the user tries to add the 6th member, it should say, 'Sorry this version allows only max of 5 members'.

Can you please help me know how to get this kind of result.

Regards and thanks much
AHVC

 

[dcx693]

If you have your users enter records via forms, then you can restrict the number of records by checking the recordcount of table. You will have to write some VBA code to check the recordcount of the underlying table like this:
Me.RecordsetClone.RecordCount