Delete record

[Phil Stanton]

Sorry to repost, but am having another look at deleting a record.

I have a form (Member) and have removed all the event procedures associated
with the Form (OnCurrent, OnDelete, OnActivate etc)
When I click on the record bar and press delete it comes up with the correct
message "You are about to delete 1 record ....", the record count drops by 1
and I say "Yes - delete it". Seems OK, record is no longer there.
Than after closing the form and re-opening the record is back and the record
count back to the original number.

Any Ideas?

Thanks

Phil

[storrboy]

On Apr 25, 5:27 pm, "Phil Stanton" <[e-mail]:

Sorry to repost, but am having another look at deleting a record.

I have a form (Member) and have removed all the event procedures associated
with the Form (OnCurrent, OnDelete, OnActivate etc)
When I click on the record bar and press delete it comes up with the correct
message "You are about to delete 1 record ....", the record count drops by 1
and I say "Yes - delete it". Seems OK, record is no longer there.
Than after closing the form and re-opening the record is back and the record
count back to the original number.

Any Ideas?

Thanks

Phil

Just ideas...
Is there anything in BeforeUpdate, or anything that could possibly
cancel an update in another event or sub? Is the Forms Allow Deletes/
Updates etc. set to true? Do you know that the recordset or underlying
table is not in a read-only state?

[King Ron]

It sounds like you intend to allow the deletion, but in fact you are
CANCELing the deletion. Make sure that the value associated with your
'Yes - delete it' button is equal to the vbCancel (object browser)
value.

King Ron of Chi
On Apr 25, 4:27 pm, "Phil Stanton" <[e-mail]:

Sorry to repost, but am having another look at deleting a record.

I have a form (Member) and have removed all the event procedures associated
with the Form (OnCurrent, OnDelete, OnActivate etc)
When I click on the record bar and press delete it comes up with the correct
message "You are about to delete 1 record ....", the record count drops by 1
and I say "Yes - delete it". Seems OK, record is no longer there.
Than after closing the form and re-opening the record is back and the record
count back to the original number.

Any Ideas?

Thanks

Phil

[Phil Stanton]

Thanks for thoughts

As I said, have temporarily removed all Form events (but not Control events)
Form is set to allow additions and deletions and as I can amend the record,
I ssume that the tables are not read-only. There is no problem if I go to
the table and delete the record even after deleting it (or more accurately,
failing to delete using the form).

Have had a thought and have tried deleting the record from the query on
which the form is based. Again it appears to delete OK, but close the query
and re-open it, and there is the record again. That eliminates any problem
with the form.

Thanks

Phil

"storrboy" <st******@sympatico.cawrote in message
news:11**********************@t39g2000prd.googlegr oups.com...

On Apr 25, 5:27 pm, "Phil Stanton" <[e-mail]:

>Sorry to repost, but am having another look at deleting a record.

I have a form (Member) and have removed all the event procedures
associated
with the Form (OnCurrent, OnDelete, OnActivate etc)
When I click on the record bar and press delete it comes up with the
correct
message "You are about to delete 1 record ....", the record count drops
by 1
and I say "Yes - delete it". Seems OK, record is no longer there.
Than after closing the form and re-opening the record is back and the
record
count back to the original number.

Any Ideas?

Thanks

Phil

Just ideas...
Is there anything in BeforeUpdate, or anything that could possibly
cancel an update in another event or sub? Is the Forms Allow Deletes/
Updates etc. set to true? Do you know that the recordset or underlying
table is not in a read-only state?

[Phil Stanton]

Thanks for coming back

Have had a thought and have tried deleting the record from the query on
which the form is based. Again it appears to delete OK, but close the query
and re-open it, and there is the record again. That eliminates any problem
with the form.

Just in case the standard delete message box has become corrupted, If I
press "Yes", the record count stays at the lower value; if I press "No", the
recordcount goes up by 1 to the original value.

Thanks

Phil
"King Ron" <Ki***************@covad.netwrote in message
news:11**********************@r30g2000prh.googlegr oups.com...

It sounds like you intend to allow the deletion, but in fact you are
CANCELing the deletion. Make sure that the value associated with your
'Yes - delete it' button is equal to the vbCancel (object browser)
value.

King Ron of Chi
On Apr 25, 4:27 pm, "Phil Stanton" <[e-mail]:

>Sorry to repost, but am having another look at deleting a record.

I have a form (Member) and have removed all the event procedures
associated
with the Form (OnCurrent, OnDelete, OnActivate etc)
When I click on the record bar and press delete it comes up with the
correct
message "You are about to delete 1 record ....", the record count drops
by 1
and I say "Yes - delete it". Seems OK, record is no longer there.
Than after closing the form and re-opening the record is back and the
record
count back to the original number.

Any Ideas?

Thanks

Phil