Pass-the-reality said:
I have three individual forms. I am setting the database up for form #2
to
be attached to the main form and form 3 to be attached to form 2. On form
#2
I have a field called Package ID Number. How can I show on the main form
a
list of all the Package ID Numbers that have been keyed into the # 2 form
that is tied to that main form....? I hope I explained this OK
Forms aren't the basis of a database; tables and data storage are the basis
of a database -- yes, there are some other database products which might
mislead you to think that forms are a key item... forms just provide the
user interface to the _data_ which is what a _data_base is all about.
AFAIK, there's no Access feature for "attaching" one form to another...
there is a thing called a Subform Control into which you can embed a Form or
use in Datasheet View; and you can have a Subform Control embedded in a Form
that is itself is embedded in a Subform Control. You can also Open a Form
from within another Form, but once opened, that second Form is independent.
Still, the key concept is that the forms display and allow manipulation of
the data; they don't define it or how it is structured.
So, clarify the data you have, how it is stored (the Tables and
relationships between them), and a little more explanation of what you're
trying to accomplish instead of how you think you should do it (e.g., show
on the main form a list of all Package ID numbers that have been keyed into
the #2 form...), and you vastly increase the chances that someone will be
able to offer a useful suggestion.
Larry Linson
Microsoft Access MVP
