Requery won't update unbound field calculations - advice please

[John Baker]

Hi:
Hi:

I have a form which is based on a query, and is being used to update a table. It all works
well, except for one thing. I have a number of unbound calculation fields (total value,
Labor Value, etc) which are based on the contents of the records. Within the records
themselves there are also calculated fields (Line item value). When I change a critical
field (price per unit), and do a Refresh (through a macro linked to the after update event
on the field), it recalculates the LINE item value (that is, the value for this record),
but does NOT recalculate the unbounded field values (Total Labor value etc).

How do I force recalculation of unbounded calculations? These are on the same form, and
used the same data as the line items.

A bit perplexing, and the manuals are less than helpful on this point.

Regards

John Baker

[Wayne Morgan]

Normally, the calculations are done almost as soon as you type in the value,
depending on what the calculation is. However, there are some that won't.
Try Me.Recalc to see if that will redo them.

--
Wayne Morgan
MS Access MVP
"John Baker" <Ba******@Verizon.net> wrote in message
news:fe********************************@4ax.com...

Hi:
Hi:

I have a form which is based on a query, and is being used to update a table. It all works well, except for one thing. I have a number of unbound calculation fields (total value, Labor Value, etc) which are based on the contents of the records. Within the records themselves there are also calculated fields (Line item value). When I change a critical field (price per unit), and do a Refresh (through a macro linked to the after update event on the field), it recalculates the LINE item value (that is, the value for this record), but does NOT recalculate the unbounded field values (Total Labor value etc).
How do I force recalculation of unbounded calculations? These are on the same form, and used the same data as the line items.

A bit perplexing, and the manuals are less than helpful on this point.

Regards

John Baker

[John Baker]

Wayne:

Thanks a lot that works very well indeed! Just exactly what I needed!

Regards

John Baker

"Wayne Morgan" <co***************************@hotmail.com> wrote:

Normally, the calculations are done almost as soon as you type in the value,
depending on what the calculation is. However, there are some that won't.
Try Me.Recalc to see if that will redo them.