How to set limit of rows in Table

[vaibhav2015]

Hi,
Can you please guide me how to set limit of rows in table.

example: I want to add only 130 rows in table. when user try to add new row 131 access should not allow him and give message "Exceeded Rows limit".

Thanks,

 

[bob fitz]

This can be done using by setting some code in the forms Before Update event which would use the DCount() function to find the current number of records and if it returns 130 it would cancel the update and give the required message to the user.

 

[vaibhav2015]

Thanks for your help, it work.

 

[bob fitz]

Glad to be of help. Perhaps you would be good enough to mark the thread as solved.