>> Moving to a subform

[Guest]

Hi, I are trying to identify a means of knowing that the user is
entering/moving to a subform (as opposed to moving to another record) before
the beforeupdate event on the main form.

My testing of all the events such as onenter of the subform control all
occur after the beforeupdate event on the parent form, i.e. too late. Does
anyone have any ideas worth trying?

Thanks
Jonathan

 

[John Vinson]

Hi, I are trying to identify a means of knowing that the user is
entering/moving to a subform (as opposed to moving to another record) before
the beforeupdate event on the main form.

My testing of all the events such as onenter of the subform control all
occur after the beforeupdate event on the parent form, i.e. too late. Does
anyone have any ideas worth trying?

I've tried to do this, and the only solution I've found is to have the
subform disabled. Put a command button on the mainform to run your
code, enable the subform, and set focus to an appropriate control on
the subform.

John W. Vinson[MVP]

 

[Guest]

John thanks for your response. Controlling user navigation does seem to be
the key to this.

Thanks
Jonathan