Updating a value from a subform to the main form

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
 
G

Guest

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
 

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

Changing a value on a parent form from values on a subform 7
Referencing a control on a sub form (Post 2) help, please? 13
Problem with referencing control on On Current event of continuous form 1
Cannot set value via event 14
Referencing a control on a subform 2
You can't assign a value to this object 3
Open form populated with data from query and update table with cha 2
Completing field on subform from command button on main form 3

Top