How refresh list box on a form from a subform on the same form?

M

mscertified

I have a form with a subform on it and also a list box.
The subform determines what must appear in the listbox.
Whenever a row is updated, added or deleted in the subform, I need to
refresh the listbox. How do I do that and how do I refer to the listbox from
in the Subform after update event?
- David
 
R

RuralGuy

You can also reference the listBox with: Me.Parent!ListBoxName.Requery

try this
Forms![MainFormName]![ListBoxName].Requery
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Top