Requery a subform

[Gina Whipp]

Hey All,

Hope I explain this so it makes sense...

I have a activities form (frmInputActivities) with a list box
(lstCategories) and a subform (sfrInputActivities). When you click on a
Category in the list box it brings up the corresponding records in the
subform. However, if you select a category and go to the subform and click
on an activity at the bottom of the subform and then go back and select a
category the list doesn't requery to show all the activities under that
category.

I put a Forms!frmInputActivities!sfrInputActivities.Requery it doesn't work
I still don't get all the activities listed under the category selected.
And Repaint gives me an error that the object does not support that action.
Any ideas what I can do to fix this?

Thanks in advance!
Gina

 

[Steve Schapel]

Gina,

Try this on the listbox's AfterUpdate event...
Me.sfrInputActivities.Form.Requery

- Steve Schapel, Microsoft Access MVP

 

[Gina Whipp]

THANKS Steve... that worked perfect!

I guess I couldn't see the forest for the trees!