When to requery a form??

[PNGBill]

Hi Forum,

Have a form, with subforms, that includes a command button which when clicked takes you off to do a task.

When the task is over and you click Exit on the task form to return to this form, where should I use Re query - which event is best to use??

Sorry for being a bit lazy as I could try different options but thought an Experts opinion to be good to get as well.

The options I can see are:
On Current
On Open
On Got Focus
others??

Appreciate some advice as the wrong option may work but give unexpected problems elsewhere.

 

[PNGBill]

I have researched a little in access help and added Me.Requery to the Activate Event of the form.

Help suggests this doesn't work on the Sub Forms but it does the job in our case as the subform was updated where the event had been added and wasn't where no event.

If I am on the wrong track, appreciate any guidance before the wheels fall off and we have to go back to ledgers