Multi Table form

key1pop1

New member
Local time
Today, 13:31
Joined
Jun 6, 2011
Messages
8
Hey all,

My question involves 3 different tables (each table controls a combo-lookup box which I want to be able to add fields to at anytime, the tables just have 1 key field and 1 detail text field). All three tables are not related to each other, nor do they need to be. I wanted to save space and amount of forms I am using, so I am trying to make 1 form which will allow the user to add records to each of these tables. Is this possible? or is there no easy way to force a form to control 3 unrelated tables.

I did some searching and I feel like sub forms may be the key but I am not too familiar with using those yet.

Thanks in advance!

PS I am using Access 2010, on windows 7
 
if that's what you want to do and the are unrelated...sure.

Open a New form in Design view - Main form
The add the 3 forms as subforms to it...you wouldn't need to worry about linking the parent - child stuff because it's not there.

So you'll basically have 4 forms - (the main will house the other 3)
 
if that's what you want to do and the are unrelated...sure.

Open a New form in Design view - Main form
The add the 3 forms as subforms to it...you wouldn't need to worry about linking the parent - child stuff because it's not there.

So you'll basically have 4 forms - (the main will house the other 3)

That was so easy I feel dumb, thanks man!
 
Hopefully that will work for you!

Welcome to the forum!
Larry
 
Hopefully that will work for you!

Welcome to the forum!
Larry

Thanks!

So here is a follow up question that is a tad bit tricky. I have those subforms working like a champ. I have them set up so you can add/edit records and below the header(of each sub-form) is a 'multiple items' view of all the records. Is there any way to get rid of the right side scroll bars, as well as the bottom Record scroll/filter/create bar? I have functions in each of my sub-forms which makes them obsolete and more of an eyesore than anything else.
 
Yes...

Look for the properties menu for the form...not that familiar with 2010.

you want to look for... probably somewhere in the "ribbon"

Record selector
Scroll bars
Navigation buttons

HTH
Larry
 
Genius!

I promise I am done with this topic now, thanks for all your help!
 
haha...I wish I were!

There are many many of those guys here!

you're welcome!
Larry
 

Users who are viewing this thread

Back
Top Bottom