Timing error on form

[Amy Blankenship]

I have a form that is in a subform control and itself contains a subform.

I had always assumed that I could use the Current event of the form and
access the values that are going to be shown in the form for that record.
But I have a situation where when the Current event fires, the primary key
value used in a hidden text control "lags behind" the loaded values.

So, when the form's current event fires the first time, the value is 0.
When it fires the second time (on navigate to record 2), the value is 1.

What could be causing this, and is there a different event I should look at
to get accurate values here?

Thanks;

Amy

 

[Amy Blankenship]

Never mind. Compact and repair fixed it...