One control equal another control ?

[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.

 

[Guest]

hi,
If the control are on the same form try:
me.disc = me.seniordisc