Form Calculation

  • Thread starter Thread starter Gustavo
  • Start date Start date
G

Gustavo

Hi Everyone,
I have the following controls in an Access 97 form with
a table as the source and the default view as "Continuos
Form":

Control-A.Source = Sale (a dollar amount)
Contro-B unbound (pct format)
Control-C.Source = Control-A * Control-B

The problem is that when I enter a percent value in
Control-B it goes to every single record in the form and
I need to enter one different percent to every record.
I hope I am being clear in my explanation and some
generous soul can help me out...I am getting desperate
because my deadline is real close.
Thanks in advance
Gustavo
 
I got it! Thanks a lot Ngan
-----Original Message-----
This is by design. Since Control B is unbound, whatever
you enter in there will be the same for all records.

If you want it to be different for each record, you need
to have it bound. Create a field in the table for the
percent and have control B be bound to it.

As for Control C, I assume it's just a calculated field
and not bound to anything in the table.

Ngan

.
Click to expand...
 
Back
Top