Creating form with tab controls

[qpurser]

Hi,
I created about 5 forms (custumors, invoices, ....)
I would like to use now the access2 tab control form to switch between
these forms.
I was trying to copy each form in a tab control page...
But this seems not to work...
Any suggestions?
THX
Mike

 

[Al Campagna]

Mike,
The most common mistake when placing forms/subforms on Tabs is
"selecting" the appropriate tab before "pasting" the subform onto it. You
can not "drag" a subform onto the Tab
Place your subform on the form... anywhere.
SELECT the subform and CUT it. (Shift-Del).
SELECT the individual Tab that will contain this particular Subform.
PASTE the Subform. (Shift-Insert)

You should see the Subform appear on that Tab, and only that Tab.
Continue the same process for the remaining subforms, pasting to a
different tab each time.

 

[qpurser]

Thx for help.
But it seems not working for me...
My forms are not always realted to each other.
Can each tab with his own form have a different source?
The first tab is working...the rest won't let me edit or ad data...
Mike

 

[tina]

-----Original Message-----
Hi,
I created about 5 forms (custumors, invoices, ....)
I would like to use now the access2 tab control form to switch between
these forms.
I was trying to copy each form in a tab control page...
But this seems not to work...
Any suggestions?
THX
Mike
.
hi mike.

first of all, if you're trying to literally copy the
subform object in the database window and then paste it
into the main form, you're right - it won't work.

but getting the subform into the main form really is a
simple drag and drop operation. here's how:

1. create the TabControl on the main form (if you haven't
already done so).
2. restore the form design window, so you can see the
database window behind it.
3. while still in the main form design window, click on
the specific tab you want to place the subform on, so that
tab is selected.
4. in the database window, click on the subform and drag
it into the main form design window, taking care to drop
it directly on the tab page. you'll know you're on target
when the interior of the tab page turns solid black,
before you "drop" the subform.

if you still have trouble getting it to work, you can
email me and i'll help you out. to answer your second
posted question, yes - each subform can have it's own
record source, and run independently from the main form.
you can have both "child" subforms and independent
subforms on a main form. the tab pages themselves do not
have record sources, of course.

 

[qpurser]

Hi Tina,
Thx for offering to help me.
I tried your suggestions but it seems not to work.
Perhaps I need to explain a little more.

My intention of the whole thing with these tab controls is to create
some kind of menu (like a switchboard)
I have created 4 forms (all with events), but I guess when I figure
out how the first two work I can do the others by myself.
- Customers (the form has combo box to lookup a customer and the
results are displayed in a
subform that displays the orders he did)
- Orders ( the form has also a combobox where I lookup a customers
information and in the
subform I can ad new products he is ordering.
- Products (in this form a lookup, ad and delete products)
So I would like to have a tab control form with 4 tabs (1 for each
form) so the user can easily switch between them.

As you suggested I created the tab control form and dragged each of my
forms in his own tab.
The first tab works fine.
On the others I can't get to work the combo boxes and I even can't ad
records.
Sometimes Access also crashes...

I hope you are the brain here
Regards,
Mike