Record on form

  • Thread starter Thread starter K
  • Start date Start date
K

K

Good day.

How do I stop a DBase from adding new records when I come to the end of the
field / control on a form? for example once a record is created I dont want
to automatically create a new record unless I click on a command button to
add new record. Any help would be appreciated. Basically I want to freeze the
record I am working on

Thanks in advance.
 
K said:
Good day.

How do I stop a DBase from adding new records when I come to the end of
the
field / control on a form? for example once a record is created I dont
want
to automatically create a new record unless I click on a command button
to
add new record. Any help would be appreciated. Basically I want to freeze
the
record I am working on
Click to expand...


Access wouldn't normally actuall *add* a new record, but it will by default
move to a new blank record for you to fill in. However, you can set the
form's Cycle property to "Current Record" to forestall this behavior.

That will still leave the user the ability to navigate to the new record in
a variety of ways. If you really want to prevent the user from adding a new
record unless you say it's okay, you can manipulate the form's
AllowAdditions property. You could start with the property set to No, then
on your button click set it to Yes and move to the new record, and in the
form's AfterInsert event set the property back to No.
 
Back
Top