Code to Refresh Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I've done this before, but it's been so long I forgot how to do it. I have a
form that uses a combo box to look up students and then it places the
StudentID in the table, the date of their request, and the date the request
was honored.

I also have a subForm on the right side of the screen that displays the
student's name, office, email address, and phone. When a new record is saved
the subform does NOT display the student's informatiin. However, if I move
off the record and then back to the new record I just created, it will
accurately display the student's info. I disabled all of the fields on the
subform so it will be read only.

What code do I need? Where do I put it? And what event should I use?

Thanks,
Robert
 
Dennis:

I placed Me.Requery in the Form's After Update event and that messed up
saved records. For reasons I don't understand, I couldn't save a new record.

Anyway, I removed it from the After Update event and everything worked
perfectly. I added some other code and now when the user clicks the Save
button, the subform refreshes instantly.

Thanks,
Robert
 
Back
Top