Refresh data between forms
Put the Refresh in the form's Activate event.
"Sandy" wrote:
I am trying to create a database for our local Parks & Rec department and
have a question about refreshing data between forms. Perhaps I have
something set up incorrectly or not smartly :-)
I have a main form (HouseholdRegistrations) w/a subform (StudentsRegistered)
that shows me all the children registered to this household. There is a
linked field on both (HouseholdID)
On the StudentsRegistered subform, I also have a button to open another form
to registered a child for another class.....Main form
(RegistrationForm)/Subform (RegistrationsSubform). Everything is set up so
they chose the class they want to register from a pulldown list.
I currently then exit this form and I am returned to the first form listed
above (HouseholdRegistrations) w/a subform (StudentsRegistered). The list of
the classes the kids are now registered for are in the subform on this form.
I had to put a refresh button on the Main form (householdregistrations) to
get the data I just entered on the Registrationsubform to show up
I just don't know how to code so please be gentle....When I close the
registration form and return to the household form, how do I get the info to
refresh without having a refresh button to also click on????
Thanks a bunch!
|