2 forms - connecting?

I asked this question yesterday but I didnt understand the answer - if
someone can send me a reply in very plain english - I really dont know access
that well!

I have one table that has information about "stores" (address ect - what
they sell - a description and so on) from this table I have created a form
with all this information on it each store has a contract number.

Each store however may have more than one branch - for example one store has
32 branches - I created another table with all the branch stores with their
address etc. In the table each branch is on a separate line because at one
point I need to print out labels.

My question is: how can I have all of the branch stores appear all at once
on another form or a sub form from my main form - I want to be able to view a
store and then push a button and have the form open up with all of the branch
stores for that particular store - I will use the Contract number as the key
to connect the two forms - but from there I dont know exactly what to do.

thanks again!!

is it as simple as having the subform in datasheet view?

"Bianca" wrote in message
...
I asked this question yesterday but I didnt understand the answer - if
someone can send me a reply in very plain english - I really dont know
access
that well!

I have one table that has information about "stores" (address ect - what
they sell - a description and so on) from this table I have created a form
with all this information on it each store has a contract number.

Each store however may have more than one branch - for example one store
has
32 branches - I created another table with all the branch stores with
their
address etc. In the table each branch is on a separate line because at
one
point I need to print out labels.

My question is: how can I have all of the branch stores appear all at once
on another form or a sub form from my main form - I want to be able to
view a
store and then push a button and have the form open up with all of the
branch
stores for that particular store - I will use the Contract number as the
key
to connect the two forms - but from there I dont know exactly what to do.

thanks again!!

Are u asking me???? cause I am so confused I dont know! What I have tried
so far is: I created a subform and entered the information right there on
the form using ctrl & enter to go to the next line (dont know if that is
correct but I did it) anyhow when I finished it seemed like the whole thing
was too much - too heavy - too slow I mean I tried a find command and it took
way too long to do it - so I figured the subform was too much - the original
form has a lot of information on it. I dont know if this was the problem or
something else.
David are u saying that this - creating a sub form is the only way??? Or is
there another way - I mean like I said before I need the info on separate
lines in order to create labels later on - by using ctrl enter to go to the
next line in the same line will my label thing work??
I hope I havent confused you - but thanks

"David F Cox" wrote:

is it as simple as having the subform in datasheet view?

"Bianca" wrote in message
...
I asked this question yesterday but I didnt understand the answer - if
someone can send me a reply in very plain english - I really dont know
access
that well!

I have one table that has information about "stores" (address ect - what
they sell - a description and so on) from this table I have created a form
with all this information on it each store has a contract number.

Each store however may have more than one branch - for example one store
has
32 branches - I created another table with all the branch stores with
their
address etc. In the table each branch is on a separate line because at
one
point I need to print out labels.

My question is: how can I have all of the branch stores appear all at once
on another form or a sub form from my main form - I want to be able to
view a
store and then push a button and have the form open up with all of the
branch
stores for that particular store - I will use the Contract number as the
key
to connect the two forms - but from there I dont know exactly what to do.

thanks again!!

Creating a subform is not the only way. You could pop-up another form on a
button press. However the original question seemed to me was "How do I show
all of the records?". One very crude way is to have the pop-up form, or
subform if you do it that way, display the records in datasheet view. You
will find that as an option in the form properties.


"Bianca" wrote in message
...
Are u asking me???? cause I am so confused I dont know! What I have
tried
so far is: I created a subform and entered the information right there on
the form using ctrl & enter to go to the next line (dont know if that is
correct but I did it) anyhow when I finished it seemed like the whole
thing
was too much - too heavy - too slow I mean I tried a find command and it
took
way too long to do it - so I figured the subform was too much - the
original
form has a lot of information on it. I dont know if this was the problem
or
something else.
David are u saying that this - creating a sub form is the only way??? Or
is
there another way - I mean like I said before I need the info on separate
lines in order to create labels later on - by using ctrl enter to go to
the
next line in the same line will my label thing work??
I hope I havent confused you - but thanks

"David F Cox" wrote:

is it as simple as having the subform in datasheet view?

"Bianca" wrote in message
...
I asked this question yesterday but I didnt understand the answer - if
someone can send me a reply in very plain english - I really dont know
access
that well!

I have one table that has information about "stores" (address ect -
what
they sell - a description and so on) from this table I have created a
form
with all this information on it each store has a contract number.

Each store however may have more than one branch - for example one
store
has
32 branches - I created another table with all the branch stores with
their
address etc. In the table each branch is on a separate line because at
one
point I need to print out labels.

My question is: how can I have all of the branch stores appear all at
once
on another form or a sub form from my main form - I want to be able to
view a
store and then push a button and have the form open up with all of the
branch
stores for that particular store - I will use the Contract number as
the
key
to connect the two forms - but from there I dont know exactly what to
do.

thanks again!!