List Box automatic update

[Dannyboy11]

I have a form whereby you select a person from a drop down and then in a sub form you can enter in marks for that person. At the bottom, I have two list boxes. One shows that persons average number, and this updates when you select a different user (so then you go back to that user to find their average).

The other list box shows the value of a query that is finding out the average of every single mark in the table. This only updates when I close the form and then re-open it.

How can I get the second list box to update like the first one (when you select a different user)? Even better, how can I get both to update after each new entry into the sub form?

Thank you

 

[HiTechCoach]

to refresh the listboxes from the sub form you could use the form's After Update to requiry.

Example

Me.Parent.ListBoxControlName.Requery


Tip: Press F9

 

[Dannyboy11]

Hi

I did what I think you wanted but nothing has changed. This is what the sub looks like.

Private Sub Form_AfterUpdate()


Me.Parent.List21.Requery
End Sub