New Record

[Guest]

Currently when scrolling through records displayed in forms, when reaching
the last record, a new record is created.

How can you have the record stop on the last record rather than adding a new
record?

Any suggestions are appreciated.........

 

[Dirk Goldgar]

Currently when scrolling through records displayed in forms, when
reaching the last record, a new record is created.

Do you mean that a new record is actually created in the underlying
table, even if you don't do anything but close the form afterward? Or
just that the form is positioned to the "new record", a blank form for
adding a new record? The latter is normal, the former would imply that
there's code running that modifies the new record immediately.

How can you have the record stop on the last record rather than
adding a new record?

Any suggestions are appreciated.........

Set the form's AllowAdditions property to No. It's on the Data tab of
the form's property sheet in design view.

 

[Guest]

Set the forms "Allow Additions" property to "No"
This can be done in the design view.

 

[Guest]

Thanks Joe and for all responses. The allow additions took care of it since
it was normal behavior.

Thanks