Event inconsistency with subform

[R. Hofford]

I have a database form with multiple subforms, and I'm seeing
differences in event sequences which may be either the cause or the
result of a problem. This database isn't new, and the problem began to
surface just a couple of months ago leading me to believe it could be a
data problem. (I haven't made any changes for some time.) However, it
doesn't seem to be.

What I see is that I'm getting a Before_Update event for one of the
subforms when I'm expecting the Current event. The actual problems are
caused a value referenced in the event code being null. I don't
understand why the value should be null even if the Before_Update event
is happening, but the two things happen consistently together.

I'm using Access 2002 (Access 2000 file format).

Any advice in how to debug this problem would be greatly appreciated.

Ro Hofford

 

[Guest]

This might be the result of the null value being a required field? Go to the table and check the field to see if the required property is set to yes.

HTH,
Vlad C

 

[R. Hofford]

Thank you, but I don't think that is the problem. Any non-autonumber
fields are set to No for Required. The real mystery is why the problem
happens only intermittently.

Ro