Trying to Change a Variable in Main Form from Subform

[Talnus]

From an OnChange in VBA in a SUB form I am trying to change a value in the main form.

Basically this is to let me know at a quick glance if any of the data has changed on the sub form.

Any Ideas?

[MikeTheBike]

From an OnChange in VBA in a SUB form I am trying to change a value in the main form.

Basically this is to let me know at a quick glance if any of the data has changed on the sub form.

Any Ideas?

Hi

Try this in the on current even

Me.Parent.txtCo ntrolName = "Value to be set"

Any question/problems, please ask.


MTB

[NeoPa]

Your code on the sub-form can refer to the main form as Me.Parent. From there only you know which controls are available and which should be updated.

Welcome to Bytes!

[Talnus]

Awsome this was to simple, it worked perfectly Thank you