What events fire when returning from a modal pop-up form?

[PacFreshAnthony via AccessMonster.com]

I have an unbound form with a list box, and a command button that opens a
modal pop-up form that adds records directly related to the list box. I want
the list box to be requeried onced the pop-up form is closed. Where is the
best place to put the requery code?

Thank you,
Anthony

 

[Tom van Stiphout]

On Thu, 30 Oct 2008 13:32:51 GMT, "PacFreshAnthony via

In the popup's Form_Close event.
Forms!TheOtherForm!TheListbox.Requery

-Tom.
Microsoft Access MVP

 

[tina]

put it in the code that closes the pop-up form, as

Forms!FirstFormName!ListboxName.Requery

hth