Subform only requeries once

[Marisol]

I am working on a database that tracks courses/programs that we organize for
conferences. Each program has speakers (we call faculty) and a course
planner.

I have a form that allows you to enter the information about the program.
In the form, you have to enter the course planner. I have a button that,
when you click on it, it opens up the course planner subform (datasheet view)
and you can enter new course planners and their related information. Here is
a picture showing the main form open, the course planner field, and the
course planner subform is open in the foreground, if you want to get an idea:
http://www.fototime.com/0C961390A11CD13/orig.bmp.

The problem I'm having is that I can add a new course planner, close the
subform and then click the drop-down and the new person comes up in the
drop-down. BUT if you try it again, it doesn't work the second time. It
will work if I close the main form and re-open it, however.

I am using requery as an Event Procedure linked to the onClick event of the
drop-down:
Private Sub PlannerID_Click()
Me![PlannerID].Requery
End Sub

I've also tried adding this to other events but I don't get any better
results.

Any ideas?