Refreshing an listbox

[Nick Mirro]

I have a listbox sitting in a subform who's rowsource criteria is the
subform's current record. It lists all "task names" for the parent form
current record.

When I change records in a linked grandparent form, all of the subform
fields update... except the listbox.


I tried: Me![lstAllTasks].Requery

for the subform "on dirty" and "after update"
and requery with full path for the primary control in the
grandparentform.


How can I get the listbox to automatically update when related records in
its form cycle?

 

[Sandra Daigle]

You need to use Current event of the subform to requery the listbox.

 

[Nick Mirro]

Got it. Thanks much.

You need to use Current event of the subform to requery the listbox.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I have a listbox sitting in a subform who's rowsource criteria is the
subform's current record. It lists all "task names" for the parent
form current record.

When I change records in a linked grandparent form, all of the subform
fields update... except the listbox.


I tried: Me![lstAllTasks].Requery

for the subform "on dirty" and "after update"
and requery with full path for the primary control in the
grandparentform.


How can I get the listbox to automatically update when related
records in its form cycle?