Control Source For Linked Forms

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
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.
 
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
 
Back
Top