Order of events - delete record in subform

[Ian Hinson]

Hi,

I have a subform in a form in an ADP that I am creating "form-by-form" based
on an equivalent MDB front-end db.
(I'm converting from a front-end/back-end mdb structure to an AccessXP ADP +
SQL2000DE. It's amazing the number of gotchas I'm coming across in the
process.)

Like this: When I delete a record from the datasheet subform, I'm finding
that the FormDelete event runs last !
I proved that to myself (when trying to track down a bug) by putting the
following event handlers in the form that becomes the subform:

Private Sub Form_AfterDelConfirm(Status As Integer)
Debug.Print "AfterDelConfirm"
End Sub

Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer)
Debug.Print "BeforeDelConfirm"
End Sub

Private Sub Form_Delete(Cancel As Integer)
Debug.Print "FormDelete"
End Sub

The Immediate Window lists the following:
BeforeDelConfirm
AfterDelConfirm
FormDelete

This is quite different to what Access Help says (although that is still
correct for MDB forms).
Also, if deletion is cancelled by the user, then FormDelete does not run at
all, although BeforeDelConfirm & AfterDelConfirm still do.

Hopefully someone is keeping a list of "Upsizing Gotchas" so maybe I don't
have to find out all these things the hard way, since the Access Help is
little help at all these days.

Ian.

[Allen Browne]

Yep:
Order of Form Delete Events Differs in ADPs and MDBs
at:
http://support.microsoft.com/default...b;en-us;234866

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ian Hinson" <pp******@bigpond.net.au> wrote in message
news:K1******************@news-server.bigpond.net.au...

Hi,

I have a subform in a form in an ADP that I am creating "form-by-form"
based
on an equivalent MDB front-end db.
(I'm converting from a front-end/back-end mdb structure to an AccessXP ADP
+
SQL2000DE. It's amazing the number of gotchas I'm coming across in the
process.)

Like this: When I delete a record from the datasheet subform, I'm finding
that the FormDelete event runs last !
I proved that to myself (when trying to track down a bug) by putting the
following event handlers in the form that becomes the subform:

Private Sub Form_AfterDelConfirm(Status As Integer)
Debug.Print "AfterDelConfirm"
End Sub

Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer)
Debug.Print "BeforeDelConfirm"
End Sub

Private Sub Form_Delete(Cancel As Integer)
Debug.Print "FormDelete"
End Sub

The Immediate Window lists the following:
BeforeDelConfirm
AfterDelConfirm
FormDelete

This is quite different to what Access Help says (although that is still
correct for MDB forms).
Also, if deletion is cancelled by the user, then FormDelete does not run
at all, although BeforeDelConfirm & AfterDelConfirm still do.

Hopefully someone is keeping a list of "Upsizing Gotchas" so maybe I don't
have to find out all these things the hard way, since the Access Help is
little help at all these days.

Ian.

[Lyle Fairfield]

Ian Hinson wrote:

Hi,

I have a subform in a form in an ADP that I am creating "form-by-form" based
on an equivalent MDB front-end db.
(I'm converting from a front-end/back-end mdb structure to an AccessXP ADP +
SQL2000DE. It's amazing the number of gotchas I'm coming across in the
process.)
It's not amazing to me although I am still dazed and confused by the
experience.
Like this: When I delete a record from the datasheet subform, I'm finding
that the FormDelete event runs last !
This is quite different to what Access Help says (although that is still
correct for MDB forms).
Well, Access Help has never been accurate about anything. It can give a
bit of direction, but I think one should never accept what it says
without testing.
Also, if deletion is cancelled by the user, then FormDelete does not run at
all, although BeforeDelConfirm & AfterDelConfirm still do.
Of course, you may have found this on a Monday. It is not necessarily
true that you will find the same results on Tuesday. I have found ADPs
to be erratic to the extreme.
Hopefully someone is keeping a list of "Upsizing Gotchas" so maybe I don't
have to find out all these things the hard way, since the Access Help is
little help at all these days.

I started but ran out of disk space, (160 gigs), and so gave up.
--
Lyle Fairfield