Tabs in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if it is possible to setup multiple tabs in a access form. I
would like to set it up where I can enter a employee stats such as call time
productivity and Utilization. I tried to set this up already and it seems
each tab has the same information that is entered in a previous tab. Is there
a way to prevent that?
 
Keit said:
I was wondering if it is possible to setup multiple tabs in a access
form. I would like to set it up where I can enter a employee stats
such as call time productivity and Utilization. I tried to set this
up already and it seems each tab has the same information that is
entered in a previous tab. Is there a way to prevent that?
Click to expand...

A TabControl is just a way to organize one form bound to one form or query.
If you want different data sources per tab page then you need to put
subforms on them.
 
The problem is you placed the controls not on the first tab, as you thought,
but on the main part of the form. Here's a mini-tutorial that will steer you
towards using tabbed pages correctly:

First thing to remember is that the Tabbed Pages are all part of a single
form; think of it as a really long form turned on its side. Because it is all
one form, all referrencing to any contol on it is done in the same manner as
if they were all on one single screen. Create a form in Design View. Goto the
toolbox and click on the Tabbed Control icon; it actually looks like several
manila file folders. Place it on your form and adjust the size to your liking.
If you need more than the two tabbed pages it initially gives you, click on
the tabbed control to select it. Goto Insert and click on Tabbed Control Page
and another tabbed page will be added. Do this as many times as neccessary.

This is the really important part: when you go to add a control to a tabbed
page, you must first click to select one of the pages, then add the control.
Otherwise, the control will be added to the form itself, and will show thru
on all tabbed pages!

Once you have the form's Control Source (your table or a query) set up, you
simple add controls as you normally would, heeding the above paragraph.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Back
Top