Control Source For Linked Forms

F

FARAZ QURESHI

I have a form "Sales" with fields:
1. TransactionNumber;
2. SalesAmount;

I have a Child Form "Details" linked with a button on the Main Form "Sales"
with the following fields:
1. Transaction (Linked with/looked up from the Sales' form's field
TransactionNumber);
2. Salesman;
3. Commission (Percent)

Now, I want an unbound text box to show Commission in Number as
(Commission*SalesAmount) with Sales Amount which is selected from the main
form.
 
M

Mrs. Ugh

It depends a little where you put your unbound control. If you put it on your
subform, just enter the following formula in the Control Source line on the
Data tab of the properties window.
=Me![Commission]*Forms![Sales]![SalesAmount]
Jill
 
Top