Update a subform field based on change made to main form

  • Thread starter Thread starter norm
  • Start date Start date
N

norm

I have a form called "frmEquip" with a field called "Process", What I need
to do is when that field value is changed to reflect onto a field called
"AssgnCD" my subform called "frmBottom"? If there is no change to that
field on the main form, do not make the change to the subform, I have tried
several options, I just can't get it to work.
Thank you all for your time.
 
In that you are wanting to do this indicates there is a problem with your
database design. You care carrying redundant data.
What is the purpose of carrying this data in two tables?
This will only take extra disk space and runs a very high likelyhood of
getting out of sync and becoming incorrect.

But, to answer your question, use the After Update event of the control the
Process field is bound to. You say the name of the subform is frmBottom,
but you don't use that. You use the name of the subform control on your
main form that contains the form frmBottom.

Me.SubFormControlName.Form.AssgnCD = Me.Process
 
Back
Top