BeforeUpdate not firing

[Lars Brownies]

To prevent corruption I'm working with an unbound field in my form. The
unbound field's afterupdate event puts the value in the underlying memofield
and saves it. The form's beforeInsert doesn't fire when I start on a blank
record and when the unboud field is the first field that is entered.

In the form's beforeInsert event I have code that enters some values in
different fields.

How can I fix this so when the user starts with the unbound field, that the
form's beforeInsert gets fired and the values get entered?

Thanks,

Lars

 

[Graham Mandeno]

Hi Lars

You could check to see if action is required and call BeforeInsert
"manually":

If Me.NewRecord and IsNull(Me.[some field that gets a value]) Then
Call Form_BeforeInsert(0)
End If

The next question is where to out this code?

If you can wait until txtUnboundMemo_AfterUpdate, then insert it there.

If you must have the fields populated before the user types into the field,
use txtUnboundMemo_GotFocus.

If you need to exactly mimic the BeforeInsert behaviour (execute on first
keypress) then use txtUnboundMemo_KeyPress.

 

[Lars Brownies]

Thanks Graham,

IsNull(Me.[some field that gets a value])

I can use the autonumber field for that.

If you need to exactly mimic the BeforeInsert behaviour (execute on first
keypress) then use txtUnboundMemo_KeyPress.

Good idea!

Hi Lars

You could check to see if action is required and call BeforeInsert
"manually":

If Me.NewRecord and IsNull(Me.[some field that gets a value]) Then
Call Form_BeforeInsert(0)
End If

The next question is where to out this code?

If you can wait until txtUnboundMemo_AfterUpdate, then insert it there.

If you must have the fields populated before the user types into the
field, use txtUnboundMemo_GotFocus.

If you need to exactly mimic the BeforeInsert behaviour (execute on first
keypress) then use txtUnboundMemo_KeyPress.

--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

To prevent corruption I'm working with an unbound field in my form. The
unbound field's afterupdate event puts the value in the underlying
memofield and saves it. The form's beforeInsert doesn't fire when I start
on a blank record and when the unboud field is the first field that is
entered.

In the form's beforeInsert event I have code that enters some values in
different fields.

How can I fix this so when the user starts with the unbound field, that
the form's beforeInsert gets fired and the values get entered?

Thanks,

Lars

 

[Rick Brandt]

To prevent corruption I'm working with an unbound field in my form. The
unbound field's afterupdate event puts the value in the underlying
memofield and saves it. The form's beforeInsert doesn't fire when I
start on a blank record and when the unboud field is the first field
that is entered.

In the form's beforeInsert event I have code that enters some values in
different fields.

How can I fix this so when the user starts with the unbound field, that
the form's beforeInsert gets fired and the values get entered?

BeforeInsert is not guaranteed to fire. That's the reason I never use it.