Tabbed Form setup questions

  • Thread starter Thread starter CAD Fiend
  • Start date Start date
C

CAD Fiend

Hello,

I am going to need to make a form with 4 tabs (from 4 tables). I
understand how to make the tabs, and I can get one tab to pull from one
table's field list, fine. But how can I make the form pull from more
than one table? Is that going to require a query that collects all the
fields from all of the 4 tables? What type of query will that be? Will
that present a problem with respect to the user's input some data and
then not updating that particular table related to that particular tab?

I also read in this NG that forms should be made from queries only, not
tables themselves. Is that true?

I completely confused on this issue.

TIA.

Phil.
 
CAD said:
Hello,

I am going to need to make a form with 4 tabs (from 4 tables). I
understand how to make the tabs, and I can get one tab to pull from
one table's field list, fine. But how can I make the form pull from
more than one table? Is that going to require a query that collects
all the fields from all of the 4 tables? What type of query will
that be? Will that present a problem with respect to the user's input
some data and then not updating that particular table related to that
particular tab?

I also read in this NG that forms should be made from queries only,
not tables themselves. Is that true?

I completely confused on this issue.
Click to expand...

TabPages are simply a form real-estate tool. They do not have individual data
sources. To do what you're describing you need to place a subform on each of
the TabPages with each subform being bound to separate tables.

Binding to tables is fine, but queries are easier to impose sorting and allow
you to include calculated expressions in the DataSource which is sometimes
preferable to doing the calculations on the form.
 
Rick said:
TabPages are simply a form real-estate tool. They do not have individual data
sources. To do what you're describing you need to place a subform on each of
the TabPages with each subform being bound to separate tables.
Click to expand...

Do you know of any good web tutorials on this?
Binding to tables is fine, but queries are easier to impose sorting
Click to expand...

But how do you write to the query? Would you just create a new table from the
query and write to it instead? I'm probably asking a really dumb question here,
because I'm not good with queries (but will be, you can bet on that) yet.
 
CAD said:
Do you know of any good web tutorials on this?
Click to expand...

There are penty of good general web sites on Access. I don't know of any
specializing in subforms per-se but that is not really a very difficult topic.
I would start with the Access help file.
But how do you write to the query? Would you just create a new table
from the query and write to it instead? I'm probably asking a really
dumb question here, because I'm not good with queries (but will be,
you can bet on that) yet.
Click to expand...

A SELE CT query is just a different way to access the data in the table. In
most simple SELECT queries you simply edit the data in the query and the edits
are applied to the tables.
 
Back
Top