listbox.requery doesn't work

[supmktg]

On my main form I have a listbox that shows recent and upcoming student birthdays. When I add a student's birthday, I have a refresh button that should requery the list. Unfortunately, the refresh button does not work.

(If I hit F9, it does refresh the list.)

Here is the rowsource of my listbox:

SELECT Format([student_DOB],"mmm dd") AS ShowBday, [Student_Last] & ", " & [Student_First] AS Student, tblHighSchools.HS_Name
FROM tblStudents INNER JOIN tblHighSchools ON tblStudents.Student_HS = tblHighSchools.HS_ID
WHERE (((DateSerial(Year(Date()),Month([Student_DOB]),Day([Student_DOB]))) Between Date()-30 And Date()+30) AND ((tblStudents.Student_DOB) Is Not Null) AND ((tblStudents.Student_ActiveStatus)="Active"))
ORDER BY DateSerial(Year(Date()),Month([Student_DOB]),Day([Student_DOB])), [Student_Last] & ", " & [Student_First];

Can someone help me figure out why

Me.lstBdays.Requery

doesn't work?

Thanks,
Sup

 

[supmktg]

Never mind...I figured it out.
For anyone having this same issue,

me.Recalc

does the trick.