If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Refresh data between forms
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! |
#2
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|