ms access 2007 - How do you find out if a control is located on a tab control? -
hopefully should easy, although after searching cant figure out.
how find out if control located on tab?
if ctl.controltype <> 'tab controls' ..... end if the reason doing have piece of code runs through controls on form, runs problem when cycling through controls on tab.
if ctl.parent.currentview <> 2 msgbox ctl.name end if the above causes error:
error: 348 object doesnt support property or method obviously appears cant refer current view of tab control
cheers advice 1 has got out there
noel
check ctl before using currentview:
select case ctl.controltype case accheckbox ' check box case actabctl ' tab control end select
Comments
Post a Comment