Change Page Order on Tab Control

[Guest]

Is it possible to change the Page order on a tab control, I have 3 pages
Registrants
Events
Reports

when the form opens iwant it to look at a query and if the count is >1
change the page order to
Events
Registrants
Reports

so something like

if dlookup("count","eventcount")>0 then
me!tabctrl18 = new page order
else
me!tabctl18= old page order
end if


thanks

 

[Alex Dybenko]

hi,
you can use PageIndex property to do so:

if dlookup("count","eventcount")>0 then
me("pageEvents").PageIndex=0
else
me("pageRegistrants").PageIndex=0
end if


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Perfect Alex

Thanks

hi,
you can use PageIndex property to do so:

if dlookup("count","eventcount")>0 then
me("pageEvents").PageIndex=0
else
me("pageRegistrants").PageIndex=0
end if


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com