update tabs

[drkhelmt]

I have a database for sales to use for quotes. On one form, I have some tabs where they enter details about the quote. The last tab is a totals tab. If they close the form then reopen it, the totals are all filled in. How can I get the totals to calculate without the salesmen having to close the form and reopen it?

I've tried to save the record when the click on "Totals" but that didn't work. I tried to requery the list boxes used in calculating the totals.

Any help is appreciated.

Andrew
a.k.a. Dark Helmet

"What's the matter Colonel Sandurz? Chicken?

 

[vburrows]

Is the calculation done on close or open of the record/form




Levi B.

 

[TheAceMan1]

How are ya drkhelmt . . . . .

Try Me!Requery

See Ya! . . . . . .

 

[PHV]

You may also consider the Recalc method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886