T
Tom
Experts,
I need some help with modifying 2 functions "Previous" and "Next"
(navigation buttons for a tab control -- in a form footer)
I thought I had this working properly that now I realize that there is a
small "fluke" with the navigation buttons. I'm wondering if anyone knows
how to modify the functions. I'd be more than happy to post the entire VBA
of frmSurvey but it's pretty lengthy.
Instead, to follow this better, I have posted a small sample db
(PreviousNext.zip) at the following site:
http://tombock2004.i8.com/Test
Here's what's happening:
a. open up frmSurvey
b. on page 1, select any value from the combo box. Then click "Next". This
works fine... I'm now on page 2.
c. on page 2, do the same as in b)... now I'm on page 3.
d. on page 3, do the same as in c)... now I'm on page 4.
Here are the 2 minor problems:
1. once I "navigated" to page 4, the "Next" button is disabled. As long as
I stay on page 4 (last page) it's fine; however, once I move back to either
page 3 or page 2 or page 1, the "Next" button should be enabled again...
just in case I need to go forward one more time.
2. If I moved from pages 1 to 2 to 3 to 4 and then go back to page 1, the
"Previous" button stays enabled on Page 1 (first page).
If I were to click it "Previous" again, I get an error that indicates that
Access can't find Tab 0. Moreover, if I had clicked "End" on the Debug
window and then click "Previous" yet another time, I get the same error
message again... now it indicates that it can't find "Tab -1".
To recap... the function should be written that the following is true:
a. on page 1, only the "Next" button is enabled (whether I go forward for
the 1st time or I've come back to page 1)
b. pages 2 and 3 are ok
c. on page 3, the "Next" button should disabled... however, based on the
criteria in b), "Next" must be enabled again once I navigate back from page
4 to page 3.
If you feel comfortable downloading the sample file (as posted at the
beginning of the message), the process can be easily followed.
I appreciate any help that would solve this problem.
Thanks,
Tom
I need some help with modifying 2 functions "Previous" and "Next"
(navigation buttons for a tab control -- in a form footer)
I thought I had this working properly that now I realize that there is a
small "fluke" with the navigation buttons. I'm wondering if anyone knows
how to modify the functions. I'd be more than happy to post the entire VBA
of frmSurvey but it's pretty lengthy.
Instead, to follow this better, I have posted a small sample db
(PreviousNext.zip) at the following site:
http://tombock2004.i8.com/Test
Here's what's happening:
a. open up frmSurvey
b. on page 1, select any value from the combo box. Then click "Next". This
works fine... I'm now on page 2.
c. on page 2, do the same as in b)... now I'm on page 3.
d. on page 3, do the same as in c)... now I'm on page 4.
Here are the 2 minor problems:
1. once I "navigated" to page 4, the "Next" button is disabled. As long as
I stay on page 4 (last page) it's fine; however, once I move back to either
page 3 or page 2 or page 1, the "Next" button should be enabled again...
just in case I need to go forward one more time.
2. If I moved from pages 1 to 2 to 3 to 4 and then go back to page 1, the
"Previous" button stays enabled on Page 1 (first page).
If I were to click it "Previous" again, I get an error that indicates that
Access can't find Tab 0. Moreover, if I had clicked "End" on the Debug
window and then click "Previous" yet another time, I get the same error
message again... now it indicates that it can't find "Tab -1".
To recap... the function should be written that the following is true:
a. on page 1, only the "Next" button is enabled (whether I go forward for
the 1st time or I've come back to page 1)
b. pages 2 and 3 are ok
c. on page 3, the "Next" button should disabled... however, based on the
criteria in b), "Next" must be enabled again once I navigate back from page
4 to page 3.
If you feel comfortable downloading the sample file (as posted at the
beginning of the message), the process can be easily followed.
I appreciate any help that would solve this problem.
Thanks,
Tom