Dumbfounded
Registered User.
- Local time
- Yesterday, 18:39
- Joined
- Jul 26, 2007
- Messages
- 92
Hi Guys,
It's been a while but I have moved back into a job where they have requested databases and I'm a little out of practice.
It is a relatively simple database, a survey no less. I have broken the survey down into sections and placed these onto a tabbed sheet. Now, knowing staff as I do, I don't want any of the tabs skipping so I have put navigation buttons on the bottom of each survey section so it can take them to the next sheet and previous sheet. I have done this with macros.
However, thinking that was a mark of sheer genius on my part (der), I now realise that it actually isn't opening the linked sheet to my master sheet. I have set the macro to open the sub sheet but I need it to open the linked sheet so that the information is saved - is there a way. Any help would be greatly appreciated.
TIA
Donna
It's been a while but I have moved back into a job where they have requested databases and I'm a little out of practice.
It is a relatively simple database, a survey no less. I have broken the survey down into sections and placed these onto a tabbed sheet. Now, knowing staff as I do, I don't want any of the tabs skipping so I have put navigation buttons on the bottom of each survey section so it can take them to the next sheet and previous sheet. I have done this with macros.
However, thinking that was a mark of sheer genius on my part (der), I now realise that it actually isn't opening the linked sheet to my master sheet. I have set the macro to open the sub sheet but I need it to open the linked sheet so that the information is saved - is there a way. Any help would be greatly appreciated.
TIA
Donna