best place to requery (1 Viewer)

Lanason · May 25, 2017

I am opening a subform to change detail and then closing the subform to go back to the summary form.

what is the best place to put the Me.Requery code

is it on load / activate /open / ongotfocus ........:banghead:

isladogs · May 25, 2017

It depends on other things in your form - in other words try it & see...

However, no point putting it in Form_Open or Load as both of those have already been done...

Form_Activate may work or use Form_Current

If its a list box you want updating you may need to specify that
e.g. Me.ListBox.Requery

NOTE: Refresh may do the job instead

Finally in very rare cases, I've resorted to the following to update the main form

Code:

Application.Echo False
DoCmd.Close acForm "MainFormName"
DoCmd.Open "MainFormName"
Application.Echo True

The application echo is used to prevent the screen updating whilst the form is closed & reopened

Lanason · May 25, 2017

Thanks guessed it probably wasn't open or load

but activate / focus etc are a bit more confusing

its just a summary table where the data has been changed in the detail

Minty · May 25, 2017

I would requery the summary form on the closing event of the update sub form.

[Forms]![Your_Form_Name].Requery

If it really a subform and you are hiding it on the main form, then Me.Parent.Requery should do the job.

isladogs · May 25, 2017

On reflection Minty's answer is better

The_Doc_Man · May 25, 2017

Concur with Minty. Using a GotFocus is tenuous at best since you have to be sure as to which control on the parent would get focus. Form_Activate should be a good choice but if you change windows because you had more than one form open, you would get a phantom activation. It wouldn't hurt but the _Activate routine would have to be more narrowly crafted.

Do it when the child form is closing using Me.Parent.Refresh or .Requery

Lanason · May 25, 2017

Maybe my terminology is confusing

The main form is in the form of a list of records
the other form is a totally separate form and contain the detail for just one record - is it connected using a linked field

So not and parent /subform in the context of a single form design

Lanason · May 25, 2017

main problem is I have different lists that call up the same detail form :-(
so requerying in the child would depend upon which parent opened it !!

Minty · May 25, 2017

If it's a totally separate form then pass the calling form in using OpenArgs . Use that to determine the form you are refreshing on the close event.

best place to requery (1 Viewer)

Lanason

Registered User.

isladogs

MVP / VIP

Lanason

Registered User.

Minty

AWF VIP

isladogs

MVP / VIP

The_Doc_Man

Immoderate Moderator

Lanason

Registered User.

Lanason

Registered User.

Minty

AWF VIP

Similar threads

Users who are viewing this thread