The delete button adds a row after deleting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use the delete button on the toolbar to delet a record, and then it
automatically adds one. Why? How can I turn this off? I even have the
AllowAdditions property set to no.

tia
 
It sure does NOT do that for me.

If you have AllowAdditions on (yes), then it will show you what appears to
be a new record IF the record you were deleting was at the end of the
recordset (i.e., the last record), but it's not an actual record, it's
simply an empty form into which you can add a new record.

If it's happening w/ AllowAdditions off, then you need to look at the code
and see if there's something there that's adding records anyway.
 
I use the delete button on the toolbar to delet a record, and then it
automatically adds one. Why? How can I turn this off? I even have the
AllowAdditions property set to no.
Click to expand...

This is not typical behavior. Please post the code executed by the
button.

John W. Vinson[MVP]
 
My mistake. On the last form I was looking at, allow additions is set to yes.
And yes, this behavior happens when it is at the end of the record set. I[m
worried because some fields are defaulted and show up and I think my end user
will be confused. I wish it would just leave the form blank untill they
press the Add record button.
But I guess not.

Thanks.
 
recordset (i.e., the last record), but it's not an actual record, it's
simply an empty form into which you can add a new record.
Click to expand...

I took out all defaults so that only an empty form shows. I delete the last
record, show the empty form, then close the app. If I look at the table,
there is in fact a blank record (of course, auto id has been assigned).
 
It doesnt add a record. I was trying the delete on my form that opens in add
mode (vs my others in search mode) so of course, on is added.

HB said:
My mistake. On the last form I was looking at, allow additions is set to yes.
And yes, this behavior happens when it is at the end of the record set. I[m
worried because some fields are defaulted and show up and I think my end user
will be confused. I wish it would just leave the form blank untill they
press the Add record button.
But I guess not.

Thanks.

John Vinson said:
This is not typical behavior. Please post the code executed by the
button.

John W. Vinson[MVP]
Click to expand...
Click to expand...
 
My mistake. On the last form I was looking at, allow additions is set to yes.
And yes, this behavior happens when it is at the end of the record set. I[m
worried because some fields are defaulted and show up and I think my end user
will be confused. I wish it would just leave the form blank untill they
press the Add record button.
But I guess not.
Click to expand...

Certainly, you can!

Leave the AllowAdditions property No. Set it to Yes in the click event
of the add record button - or just have that button add a new record
to the form's RecordSetClone recordset.

John W. Vinson[MVP]
 
Back
Top