New Records do not appear in Table

[Cas van Wyk]

Hi folks,

My datatable current has 200 records; since reaching this
number I cannot add new records via the form. I can
however complete the form, and "Add Record" however this
new record does not appear on my data table. Had I
deleted a record previously, the new record would have
been captured. It appears there is a limit of 200 records
allowed - how do I remove this limit?

Thanking you.

Cas van Wyk

 

[Jeff Boyce]

Access, by itself, doesn't limit the number of table rows. Is there a
chance you're working with an application written by someone else, who may
have limited the number of rows, in the way of providing a "test-only"
sample?

Good luck

Jeff Boyce
<Access MVP>

 

[RobFMS]

Cas

For the obvious question that this is, is there any code behind the form
that checks for the number of records in the table? Look for Form events
such as:
- Form_BeforeUpdate()
- Form_AfterUpdate()
- Form_Close()
- Form_Unload()

See what code exists there.

If you have a close/save button, see if there is a macro being called with
the button is clicked.

HTH

--

Rob
FMS, Inc.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Need to launch your application in the appropriate version of Access?
http://www.fmsinc.com/Products/startup/index.asp

Need software tools for Access, VB, SQL or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-