Updating a value from a subform to the main form

  • Thread starter Thread starter Kathy Webster
  • Start date Start date
K

Kathy Webster

frmClient contains subformPayments. Both forms have a field called
txtStatus.

After updating txtStatus in subformPayments, how can I make the AfterUpdate
command update the txtStatus field in the main form frmClient to match the
value I just put in the txtStatus subformPayments field?

TIA,
Kathy
 
In the AfterUpdate add

Forms![frmClient].Form[txtStatus]=Me.txtStatus

However, it is unusual to have such information duplicated. are you sure
that your information is normalised properly.

Daniel
 
Back
Top