Refresh Listbox in Subform

[Christoph Schulz]

Hi!

does someone know the trick to refresh a listbox in a subform after the
event of navigating through the datasets of a parent form. I can now only
achieve this by clicking a requery button WITHIN the subform, I can not
force the requery from the superior form.

thanks in advance,
Christoph

 

[Stuart McCall]

Hi!

does someone know the trick to refresh a listbox in a subform after the
event of navigating through the datasets of a parent form. I can now only
achieve this by clicking a requery button WITHIN the subform, I can not
force the requery from the superior form.

thanks in advance,
Christoph

Put this code in the parent form's OnCurrent event proc:

Me.SubformControlName.Form!ListboxName.ReQuery

(substituting your actual names, of course)

 

[scubadiver]

The following in the button on the main form I think should do it:

[forms]![form name]![subform].[forms]![subform name]![combo name].requery

 

[Christoph Schulz]

It works - in the OnCurrent-Event I did not go down the whole Foms Hierarchy
beginning from Me...
Thanks to both of you!

The following in the button on the main form I think should do it:

[forms]![form name]![subform].[forms]![subform name]![combo name].requery

Hi!

does someone know the trick to refresh a listbox in a subform after the
event of navigating through the datasets of a parent form. I can now only
achieve this by clicking a requery button WITHIN the subform, I can not
force the requery from the superior form.

thanks in advance,
Christoph

 

[KumbiaKid]

Hi scubadiver,

Your post, combined with a post from Wayne-I-M, also helped me to sort a
problem I was having. See my post below, subject "Cascading prompts in a form
for a query".
Cheers,
KumbiaKid

The following in the button on the main form I think should do it:

[forms]![form name]![subform].[forms]![subform name]![combo name].requery

Hi!

does someone know the trick to refresh a listbox in a subform after the
event of navigating through the datasets of a parent form. I can now only
achieve this by clicking a requery button WITHIN the subform, I can not
force the requery from the superior form.

thanks in advance,
Christoph