One control equal another control ?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have two controls from different tables on the same form
One control is named Disc
The other is named seniordisc
Disc is form the Time table.. Default is 0
seniordisc is from the Customers table
The recordsource for the form does not include any controls from the
customer table.
Instead it does a lookup for the customer via a drop down list box and then
fills it in.

The control seniordisc equals =NameB.Column(3) which is from the
Customers table
and is a discount percentage for the customer. Default is 0

I want the control Disc to be whatever the control seniordisc equals
I enter the Customers discount percentage on the Customers form


I tried [Disc] = [seniordisc]


this did not work on the current event of the form.
 
Back
Top