Update a subform field based on change made to main form

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.
 
K

Klatuu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
Update records in subform with value from main form 4
Update subform with combobox change on main form 1
How do I populate a subform field with a value from the main form? 4
Click a subform field to open relevant form 5
Requery subform Field based on different Field's value 0
Change Vaule of main form field based on subform field 7
Subform Calculated Field Used on Main Form to Sort Results 1

Top