One control equal another control ?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top