Updating a field in a form

[logopolis]

I have a field in a form which shows a figure from a query which is from a Count calculation. When I change information which realtes to this Count the figure only changes in the form when I close the form and reopen it. It does not change when I click on a refresh command button. Ideally it would refresh automatically.

Any ideas?

 

[WP]

On all of you fields that can change add the following to the AfterUpdate event:

Me.Requery


WP

http://www.neptune400.com