Tech Support Guy banner
Status
Not open for further replies.

Microsoft Access: Create a tabbed subform within another form

1 reading
5.9K views 3 replies 2 participants last post by  Anne Troy  
#1 ·
I need to create a subform with about 5 tabs that will display a variety of information gathered from a number of queries and tables, within each tab. If it is not possible, please tell me, but I had such marvelous luck with my first question, I have faith that I'll get something usable for this one. :up: Please help.

Sincerely,

Zoegirl :)
 
#2 ·
:)
Gotta take my advice with a little trepidation, girl.

I just checked this out.

Make a (main) form.
From the control toolbox, pick and draw a tabbed control on your form. It's got tabs, right? Make the control big enough to hold your first tabbed page of data.
Save your form.
Now, make form2 with the info you want on it.
Close that form.
Open main form w/forms list showing in the background.
Grab form2's NAME and drag it onto the tabbed page.

Do the same for other tabs.

That should get you started, but I can never figure out how to change the source data, or to make the data in this tabbed page match the right record you might be looking at in the main form.

Another trick that'll prolly work (maybe better yet):

Make a form with all the fields you want. THEN, created the tabbed pages with the control and drag the fields from your form into your tabbed control? I'm thinking that'll work...

Read this for a bit of info too:
http://beta.experts-exchange.com/Databases/MS_Access/Q_20659943.html
 
#3 ·
Dreamboat,

Yup, you're the ONE!!! :up: I tried this, and it worked! I did a little fudging in that I made a huge query to hold all of the data I might ever need within this form, tabbed controls included. I then added the necessary number of tabs and necessary number of fields within each tab, and just started to fill them. It works like a charm. Yes, the query is pretty big, but not to the point of locking up. I always put my data into one database (the tables), then the queries, forms and other stuff go into the main table. I then link the tables from the data databases. Cuts down on the size. ;)

As I said, you really are a Dreamboat! Thanks for all of your help, and I think I can make my way through this now. Have a great day! You sure made mine a winner :D

Sincerely,

Zoegirl :)
 
Status
Not open for further replies.
You have insufficient privileges to reply here.