Refresh Form

[Pintglass]

Hello

I am trying to get a form to refresh using the (On Got Focus) event.

I have tried Me.Refresh & Me.Requery but this does not seen to work, the form i am trying to refresh is based upon a query with a calculated field.

Regards Pintglass

 

[Galaxiom]

Refresh shows the new values in existing records.
Requery rebuilds the recordset so it shows new records.

Maybe you want Me.Recalc

 

[Pintglass]

Me.Recalc doesn't seem to work either.

For some reason the event does not seem to be firing when the form gets the focus.

Thanks Pintglass