I have this form with a field control source named [Percent]
I also have a field control source named [Amount]
I also have an unbound field with =[Percent]*DLookUp("[Amoun
ID] = " & [Forms]![frmLetterOfCredit
I need the value of this amount in the unbound field (named PctAmount) to be updated to the other field [Amount].
I want to capture the calculated amount and put it in the field [Amount] so it will be in the table.
please see pic