Hello,
Looking for help from my agony! Warning ...newbie.
trying to update a subForm field with a value or a calculation from fields in the mainForm. I am running a procedure onClick from the mainForm.
no problem getting and seeing values with the mainform
In a public procedure (onClick from mainForm) I'm trying to use a value from a calc of two fields "fieldValue1" x "fieldRate1" and I'm trying to assign this value to a record "subfieldInterest" in the Detail section of subForm (inside of mainForm. I think I've tried every iteration of the combination possible but get various errors. I will be running this through a loop so I will need to repeatedly update the records of each new line in the subForm.
the last iteration I used was Me.[subfieldInterest] = value
also tried amongst others
Forms![mainForm]![subForm].Form![subfieldIntrest] = value
Any takers? thanks in advance.