requery on parent form looses original record

[eux]

Hello everybody!

I have a Form1 with some fields and a button that opens a Form2.

Some fields on Form1 are calculated on values in Form2.

When I change something in Form2 I want calculated fields in Form1 to
be updated.

I used Forms!From1.requery on the event onClose of Form2, but this
takes Form1 to its first record. I need the record to remain the one
from where I opened Form2.

Could you help me please.

Thank you in advance

eux

 

[Allen Browne]

A requery loads the form again. If you just want to update the calculated
fields, try a Recalc instead.