Hi,
I am using the following statement to cycle between tabs in an access form
frm.Controls(TabControlName).Pages(TabPageName).PageIndex = 0
frm.Controls(TabControlName).Pages(TabPageName).SetFocus
It all works fine when the form is opened and focus is set to the 1st tab and also...
mmmm....i tried it on the main form's form load sub.
However, I've made some changes to my code using VBslammer suggestion and your suggestion of passing "me.parent.form.name " on the sub form, and that worked perfectly.
thank you, my problem has been resolved.
lopexo
Thanks RoyVidar and VBSlammer, both suggestions helped a lot, but while testing the example on FAQ702-5010, I get a type missmatch error when calling the function recursively from the subform case. any ideas...I just copied and pasted the example for testing.
thanks
call...
thanks. I am looping through all the controls in the form. the code you provided does indeed work to check whether the form is a subform or not( actually I have not gotten to the point where it actually tests for a subform) since my code does not even get there when I call the function from the...
I have a module that has a function to change the properties of all controls in a form, (i.e. font, text, color etc.) it is called when a form is opened and it works perfectly. However, I've tried to use the same code on a form that has tabs and subforms in the tabs. The control changes are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.