Form Layout problem

Hi.

I have an Access database which has three forms which open on start up. It
was an unusual design that I want to clean up. One of the forms also has sub
forms involved.

My question is if anyone knows of an easy way to extend one of the forms to
incorporate all the forms by adding a "Tab Control" with two pages which
would then allow to add the second and third page. (Hope this makes sense!)

My problem is all the code that is under lying. Is there an easy way to copy
the forms into the tab control which will automatically update the modules
to let them know the new location of the Sub forms?

Scott wrote:[color=blue]
> Hi.
>
> I have an Access database which has three forms which open on start up. It
> was an unusual design that I want to clean up. One of the forms also has sub
> forms involved.
>
> My question is if anyone knows of an easy way to extend one of the forms to
> incorporate all the forms by adding a "Tab Control" with two pages which
> would then allow to add the second and third page. (Hope this makes sense!)[/color]

You can insert a tabcontrol and put the other two forms in, from the
graphical interface, without trouble.
[color=blue]
> My problem is all the code that is under lying. Is there an easy way to copy
> the forms into the tab control which will automatically update the modules
> to let them know the new location of the Sub forms?[/color]

If the code you mean uses a lot of addresses like Forms!whatever, no,
there is no way around a (limited) re-write. Subforms cannot be found in
the Forms collection, as you are undoubtedly aware.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

Thiught as much but I was hopefull. Thanks anyhow.


"Bas Cost Budde" <b.costbudde@heuvelqop.nl> wrote in message
news:cpmg2u$6ta$1@news2.solcon.nl...[color=blue]
> Scott wrote:[color=green]
>> Hi.
>>
>> I have an Access database which has three forms which open on start up.
>> It was an unusual design that I want to clean up. One of the forms also
>> has sub forms involved.
>>
>> My question is if anyone knows of an easy way to extend one of the forms
>> to incorporate all the forms by adding a "Tab Control" with two pages
>> which would then allow to add the second and third page. (Hope this makes
>> sense!)[/color]
>
> You can insert a tabcontrol and put the other two forms in, from the
> graphical interface, without trouble.
>[color=green]
>> My problem is all the code that is under lying. Is there an easy way to
>> copy the forms into the tab control which will automatically update the
>> modules to let them know the new location of the Sub forms?[/color]
>
> If the code you mean uses a lot of addresses like Forms!whatever, no,
> there is no way around a (limited) re-write. Subforms cannot be found in
> the Forms collection, as you are undoubtedly aware.
>
> --
> Bas Cost Budde, Holland
> http://www.heuveltop.nl/BasCB/msac_index.html
> I prefer human mail above automated so in my address
> replace the queue with a tea[/color]