Refreshing calculated records on a form

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

Guest

I have a form with two subforms on it.

The subforms show calcualted values from data entered into the form.

The way that I currently update the values is by using a simple macro that
goes to the next record and than back one to the record that you are working
on. This results in updated values.

I would like to know if there's another way to accompish this where the
values would update after a field has been updated automatically.
 
Robert,

Firstly, are the calculated values based on the values entered in the form,
or on the underlying table?

If they are based on the underlying table, you will need to save the record
first.

In either case, a simple line of VBA should do the job - something along
the lines of

me.YOURSUBFORMNAME.refresh

I think that should work, though you might have to use

me.YOURSUBFORMNAME.requery

Cheers

John Webb
 
Back
Top