form field update

[Davide]

Dear all,



I am updating the field control_level of the main form from a subform. Unfortunately, the new value won't show up (and the associated table won't update) until the following iteration, so that the field is always one step behind. This is the code I use in VBA:

Forms![main_form]!Control_level = ControlLevel
DoCmd.RunCommand acCmdSaveRecord

It does work if I update a field in the same subform, as the run command will do that, but not in the parent (main) form.
Any suggestion? thanks.

Davide

[Welshgasman]

As it is in a subform you can use Me.Parent.ControlName
I would expect that SaveRecord to apply to the form it is in (the subform)?
You could try the Dirty method?

Me.Parent.Dirty = False

[Davide]

Thanks,
but I think I could have just solved adding the following line of code:

Forms.main_form.Refresh

I have to do more tests, but it seems it is working.

[moke123]

What event are you using?