Refresh field in all records

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

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
 
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
 
Back
Top