Update Text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with 4 text boxes. The 1st is for date, the 2nd is for # of
items made, the 3rd is for # of those that are not sellable. I would like
the 4th to calculate the number that are sellable based on the numbers
entered into the 2nd and 3rd text boxes. The form is set up to be Continuous
forms, and I need the 4th text to calculate across all the records. Is that
possible? If so, what's the best way to proceed?

Thanks in Advance!
 
I have a form with 4 text boxes. The 1st is for date, the 2nd is for # of
items made, the 3rd is for # of those that are not sellable. I would like
the 4th to calculate the number that are sellable based on the numbers
entered into the 2nd and 3rd text boxes. The form is set up to be Continuous
forms, and I need the 4th text to calculate across all the records. Is that
possible? If so, what's the best way to proceed?

Thanks in Advance!
Click to expand...

This will only work if the 4th text box is in the form's footer. Also, please
realize that the 4th text box will only update after the record in the
continuous form's detail section is saved.
 
Tara,
To calculate for each record, place an unbound calculated text control on the record
with a ControlSource of...
= Field2 - Field3
To show the sum across all records, place an unbound text control in the form's Footer
with a ControlSource of...
=Sum(Field2) - Sum(Field3)
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
I have a form with 4 text boxes. The 1st is for date, the 2nd is for # of
items made, the 3rd is for # of those that are not sellable. I would like
the 4th to calculate the number that are sellable based on the numbers
entered into the 2nd and 3rd text boxes. The form is set up to be Continuous
forms, and I need the 4th text to calculate across all the records. Is that
possible? If so, what's the best way to proceed?

Thanks in Advance!
Click to expand...

Add an UNBOUND control to the form.
Set it's control source to:

=[ItemsMade] - [ItemsNotSalable]

Do not store this result in any table.

Anytime you need the number of Salable items, recalculate it, as shown
above.
 
Thanks to everyone for the responses. I must have been having a lapse in
brain function, because I took a break shortly after posting this, and when I
came back, it was obvious how I needed to proceed. I guess I just needed
some fresh air to revive me.
 
Back
Top