Subform information not current

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

Guest

Currently when I enter new data into a subform (I open the subform in form
view for easier data entry) and then save and close it and go back to the
main form, I have to exit out of the database then re-enter for the new
information to show on the subform datasheet on the main form. Is there a
way to do this without exiting the database and going back in?
 
one solution would be to add a command button to the main form, which runs
code to requery the subform, as

Me!SubformControlName.Form.Requery

make sure you use the name of the "container" control within the main form
that "holds" the subform - not the name of the subform as it appears in the
Forms tab of the database window. the two names may be the same (depending
on how the subform was added to the main form), or they may be different.

hth
 
Back
Top