I might as well ask because I know if I don't someone else will. Why would you restrict a table to n records? What do you do when you reach your limit, create a new table? Something seems very wrong.
Anyway, you would have to ensure that the append only adds one record (no idea how at this point) and loop
For i = 1 To Me.txtMAXRECORDS
if that control contains a value that represents the max minus the current count. If it represents the table max, then you'd still have to append only one record at a time, but after each loop, get the DCount of the table.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.