Update listbox after new data entered

[REDaughdril]

I have a form that student grades on. I use a listbox to pick the names. I also have a pop up form for me to enter new students that are not in the pop up "query" form. I can go to my form with the grades and hit a refresh button and the listbox is updated. I would like for my data to be requeried and up to date when I close the pop form. Any suggestion.

Thanks

 

[Durien512]

i think a requery function will take care of that...

 

[Debased]

Put this in the GotFocus event of your list box:

Me.ListBoxName.Requery

After adding a new student, I assume you will return focus to the list box.

If not, try searching this forum "Refresh List Box" there are tons of threads.

Hope this helps!

 

[REDaughdril]

Ya know, it's the little things that make you feel so stupid.
It worked great.
Thanks for the help.