Refresh field in all records

[Ivor Williams]

I have a form with a subform which has the Default View set to Continuous
Form. In the subform header is a textbox which contains a value used for a
calculation in each record in the subform. If the value in the textbox in
the header is changed, I want all of the records in the subform to be
re-calculated. The problem I'm having is that only the current record is
being re-calculated. How can I have all the records re-calculate instead of
just the current one?

Ivor

 

[missinglinq via AccessMonster.com]

I think the simplest solution is going to be running an update query from the
BeforeUpdate event of the textbox. You'll need to do the recalculation in the
query.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com