Refresh Listbox in Subform

  • Thread starter Thread starter Christoph Schulz
  • Start date Start date
C

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
 
Christoph Schulz said:
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
Click to expand...

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

Me.SubformControlName.Form!ListboxName.ReQuery

(substituting your actual names, of course)
 
The following in the button on the main form I think should do it:

[forms]![form name]![subform].[forms]![subform name]![combo name].requery
 
It works - in the OnCurrent-Event I did not go down the whole Foms Hierarchy
beginning from Me...
Thanks to both of you!

scubadiver said:
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 said:
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
Click to expand...
Click to expand...
 
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

scubadiver said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top