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

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


"Nigel" <(E-Mail Removed)> wrote in message
news:CEAAD690-9FC0-463C-85F7-(E-Mail Removed)...
> 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

Perfect Alex

Thanks

"Alex Dybenko" wrote:

> 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
>
>
> "Nigel" <(E-Mail Removed)> wrote in message
> news:CEAAD690-9FC0-463C-85F7-(E-Mail Removed)...
> > 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
>
>