Thanks,
I'm not sure I follow though, I have a table with a member ID field that is set at Long integer. I need for access to disallow new entrys after the number of records on that table is at the desired max.
If this is not possible is there a way to create a Code that will publish a msgbox when this table reaches the max number that I would like to be on my table, and if so where would I place the Code or Validation rule.
Sorry i'm a beginner in Access, and I don't really understand what you mean by creating my own Sequence Number.
