Hello,
I've done a search on refreshing forms but am not sure if/how I can relate any of the solutions to my problem.
Summary: I have a main form called Accessibilty Survey Form which then through a button links to a second form called External form which has built in subforms. The Main form is for main data entry which the user would fill out and then move onto the second form to continue data entry on the current record. However, when they finish entering in data on the main form and go into the second form, there are fields on the External form which should display main form data which was just entered doesn't carry over/link to the current record. I have to close both forms and re-enter to refresh. Forms remain one form one to the next , one does not close when going into the next.
Q: Is there a way to refresh the link to the main form, like creating a button on the second form, or some other way? I have tried creating a requery button on the External form but doesn't work properly.
I'm really new when it comes to code, so please explain simply and with LOTS of detailing (Also, I'm using Access 97 if makes diff)
Thanks, (in advance)
Chris-eh
I've done a search on refreshing forms but am not sure if/how I can relate any of the solutions to my problem.
Summary: I have a main form called Accessibilty Survey Form which then through a button links to a second form called External form which has built in subforms. The Main form is for main data entry which the user would fill out and then move onto the second form to continue data entry on the current record. However, when they finish entering in data on the main form and go into the second form, there are fields on the External form which should display main form data which was just entered doesn't carry over/link to the current record. I have to close both forms and re-enter to refresh. Forms remain one form one to the next , one does not close when going into the next.
Q: Is there a way to refresh the link to the main form, like creating a button on the second form, or some other way? I have tried creating a requery button on the External form but doesn't work properly.
I'm really new when it comes to code, so please explain simply and with LOTS of detailing (Also, I'm using Access 97 if makes diff)
Thanks, (in advance)
Chris-eh