Form BeforeUpdate event

[wh00t]

I have created a beforeupdate event for a form to ensure that data is correct, however, on the last control on the form I have the following after update event

HiddenControl = "Stuff"
DoCmd.GoToRecord , , acNewRec
myList.Requery

The problem I have is that when the beforeupdate event runs I would like to cancel the afterupdate code if the beforeupdate shows cancel=true.

I believe that the beforeupdate is running between the first 2 lines of my afterupdate code.

Any way of doing this or do I have to insert the same checks in the afterupdate event?

 

[missinglinq]

Why not include

HiddenControl = "Stuff"
DoCmd.GoToRecord , , acNewRec
myList.Requery

in the beforeupdate event?

If validation fails Then

cancel=true

Else

HiddenControl = "Stuff"
DoCmd.GoToRecord , , acNewRec
myList.Requery

End If

Linq

 

[wh00t]

Thanks, sometimes I look to hard and miss the right way :}