Is there a way to have a conditional sub sub form?

I have a sub form to create an order. Most of the items in the form are for
a full pallet, sometime an order has a mixed pallet that has many items some
in different size containers on the same pallet.

I need to somehow show another form when the user chooses "mixed" on the
first form to record the content on this one pallet. There may be many mixed
pallets in an order.

thank you
Michael

Michael,

The subform is a control just like any other control, except it has a
SourceObject property. Just have your button's Click event code set the
subform's SourceObject property to the name of the form you want to see in
place of the other subform.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
I have a sub form to create an order. Most of the items in the form are for
a full pallet, sometime an order has a mixed pallet that has many items
some in different size containers on the same pallet.

I need to somehow show another form when the user chooses "mixed" on the
first form to record the content on this one pallet. There may be many
mixed pallets in an order.

thank you
Michael

Thanks Graham
I am not sure how to set this all up. Now, Mixed is a choice under the
product list. What I was hoping to do is when they choose, mixed, I could
have them fill in another form and when I make my report. the list would
include something like the following

Product pallet count
tomatoes 2
mixed 1 5 tomatoes 2.5 kilos
6 carrots 1 kilo
10 Cabbage 1 kilo
potatoes 5
mixed 1 10 tomatoes 2.5 kilos
16 carrots 1 kilo
10 Cabbage 1 kilo

the mixed being done on the other form, but I can I keep them together?
Michael


"Graham R Seach" ha scritto nel messaggio
...
Michael,

The subform is a control just like any other control, except it has a
SourceObject property. Just have your button's Click event code set the
subform's SourceObject property to the name of the form you want to see in
place of the other subform.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
I have a sub form to create an order. Most of the items in the form are
for a full pallet, sometime an order has a mixed pallet that has many
items some in different size containers on the same pallet.

I need to somehow show another form when the user chooses "mixed" on the
first form to record the content on this one pallet. There may be many
mixed pallets in an order.

thank you
Michael

Michael,

It all depends on where the data is going to. The report gets its data from
the table, not the form, so as long as you're storing the data to an
accessible place, it shouldn't be a problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks Graham
I am not sure how to set this all up. Now, Mixed is a choice under the
product list. What I was hoping to do is when they choose, mixed, I could
have them fill in another form and when I make my report. the list would
include something like the following

Product pallet count
tomatoes 2
mixed 1 5 tomatoes 2.5 kilos
6 carrots 1 kilo
10 Cabbage 1 kilo
potatoes 5
mixed 1 10 tomatoes 2.5 kilos
16 carrots 1 kilo
10 Cabbage 1 kilo

the mixed being done on the other form, but I can I keep them together?
Michael


"Graham R Seach" ha scritto nel messaggio
...
Michael,

The subform is a control just like any other control, except it has a
SourceObject property. Just have your button's Click event code set the
subform's SourceObject property to the name of the form you want to see
in place of the other subform.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
I have a sub form to create an order. Most of the items in the form are
for a full pallet, sometime an order has a mixed pallet that has many
items some in different size containers on the same pallet.

I need to somehow show another form when the user chooses "mixed" on the
first form to record the content on this one pallet. There may be many
mixed pallets in an order.

thank you
Michael

Thanks, but when they choose "Mixed" how can I tie the information to the
pallet? and is there a way to only show the sub sub form when it is needed?

thanks


"Graham R Seach" ha scritto nel messaggio
...
Michael,

It all depends on where the data is going to. The report gets its data
from the table, not the form, so as long as you're storing the data to an
accessible place, it shouldn't be a problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks Graham
I am not sure how to set this all up. Now, Mixed is a choice under the
product list. What I was hoping to do is when they choose, mixed, I could
have them fill in another form and when I make my report. the list would
include something like the following

Product pallet count
tomatoes 2
mixed 1 5 tomatoes 2.5 kilos
6 carrots 1 kilo
10 Cabbage 1 kilo
potatoes 5
mixed 1 10 tomatoes 2.5 kilos
16 carrots 1 kilo
10 Cabbage 1 kilo

the mixed being done on the other form, but I can I keep them together?
Michael


"Graham R Seach" ha scritto nel messaggio
...
Michael,

The subform is a control just like any other control, except it has a
SourceObject property. Just have your button's Click event code set the
subform's SourceObject property to the name of the form you want to see
in place of the other subform.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
I have a sub form to create an order. Most of the items in the form are
for a full pallet, sometime an order has a mixed pallet that has many
items some in different size containers on the same pallet.

I need to somehow show another form when the user chooses "mixed" on
the first form to record the content on this one pallet. There may be
many mixed pallets in an order.

thank you
Michael

Michael,

Well I don't know how you have your tables/forms set up. I presume the main
form represents the order, and the subforms represent the line items. Your
original question was about conditionally displaying subforms, but has now
morphed into a schematic issue.

As it's 12:15 AM here now, I'm off to bed, but don't worry, the beauty of
newsnet is that others will continue from this point. I'll be back in about
8 or so hours, but by then you'll probably either have a good solution or be
well on the way.

To get the ball rolling, though, I suggest you step back a second, and start
by explaining exactly what it is you're trying to accomplish. Don't assume
we know anything about your business, so describe everything in detail.
We'll also need to know your current schema (tables, fields and
relationships), and a description of your current forms, including what they
connect to. I have a feeling we'll need to redesign some stuff to get the
job done.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks, but when they choose "Mixed" how can I tie the information to the
pallet? and is there a way to only show the sub sub form when it is
needed?

thanks


"Graham R Seach" ha scritto nel messaggio
...
Michael,

It all depends on where the data is going to. The report gets its data
from the table, not the form, so as long as you're storing the data to an
accessible place, it shouldn't be a problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks Graham
I am not sure how to set this all up. Now, Mixed is a choice under the
product list. What I was hoping to do is when they choose, mixed, I
could have them fill in another form and when I make my report. the list
would include something like the following

Product pallet count
tomatoes 2
mixed 1 5 tomatoes 2.5 kilos
6 carrots 1 kilo
10 Cabbage 1 kilo
potatoes 5
mixed 1 10 tomatoes 2.5 kilos
16 carrots 1 kilo
10 Cabbage 1 kilo

the mixed being done on the other form, but I can I keep them together?
Michael


"Graham R Seach" ha scritto nel
messaggio ...
Michael,

The subform is a control just like any other control, except it has a
SourceObject property. Just have your button's Click event code set the
subform's SourceObject property to the name of the form you want to see
in place of the other subform.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
I have a sub form to create an order. Most of the items in the form are
for a full pallet, sometime an order has a mixed pallet that has many
items some in different size containers on the same pallet.

I need to somehow show another form when the user chooses "mixed" on
the first form to record the content on this one pallet. There may be
many mixed pallets in an order.

thank you
Michael

Thanks sleep well and I will post a new better thought out question and list
what I have now, probably, just doing that will help me sort it out
myself..I hope..
night
michael
"Graham R Seach" ha scritto nel messaggio
...
Michael,

Well I don't know how you have your tables/forms set up. I presume the
main form represents the order, and the subforms represent the line items.
Your original question was about conditionally displaying subforms, but
has now morphed into a schematic issue.

As it's 12:15 AM here now, I'm off to bed, but don't worry, the beauty of
newsnet is that others will continue from this point. I'll be back in
about 8 or so hours, but by then you'll probably either have a good
solution or be well on the way.

To get the ball rolling, though, I suggest you step back a second, and
start by explaining exactly what it is you're trying to accomplish. Don't
assume we know anything about your business, so describe everything in
detail. We'll also need to know your current schema (tables, fields and
relationships), and a description of your current forms, including what
they connect to. I have a feeling we'll need to redesign some stuff to get
the job done.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks, but when they choose "Mixed" how can I tie the information to the
pallet? and is there a way to only show the sub sub form when it is
needed?

thanks


"Graham R Seach" ha scritto nel messaggio
...
Michael,

It all depends on where the data is going to. The report gets its data
from the table, not the form, so as long as you're storing the data to
an accessible place, it shouldn't be a problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks Graham
I am not sure how to set this all up. Now, Mixed is a choice under the
product list. What I was hoping to do is when they choose, mixed, I
could have them fill in another form and when I make my report. the
list would include something like the following

Product pallet count
tomatoes 2
mixed 1 5 tomatoes 2.5 kilos
6 carrots 1 kilo
10 Cabbage 1 kilo
potatoes 5
mixed 1 10 tomatoes 2.5 kilos
16 carrots 1 kilo
10 Cabbage 1 kilo

the mixed being done on the other form, but I can I keep them together?
Michael


"Graham R Seach" ha scritto nel
messaggio ...
Michael,

The subform is a control just like any other control, except it has a
SourceObject property. Just have your button's Click event code set
the subform's SourceObject property to the name of the form you want
to see in place of the other subform.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
I have a sub form to create an order. Most of the items in the form
are for a full pallet, sometime an order has a mixed pallet that has
many items some in different size containers on the same pallet.

I need to somehow show another form when the user chooses "mixed" on
the first form to record the content on this one pallet. There may be
many mixed pallets in an order.

thank you
Michael

For the orders I have a order table and a orderdetail table. This is not an
ordinary business, what I mean by that is we don't have set product names
for each item we sell as the client decides how he wants the product
delivered, his choices include the product washed or un washed, if the
client wants it in a bag or in a plastic tray if in a tray the size of the
container from about 20 options. Then they choose the weight and they type
of pallet they want.

The following information is entered in the mail table,
[client] (from a drop down list drawn from the client table.)
[Destination] (from a drop down list drawn from the client table.)
[Del date] from a calendar
[TypeofPaller] from a list box
and other information such as the employees name and non important to this
question items

I have a subform that is drawn from a query of the tblorders and the
tblorder details

The following information is stored in the order detail

A drop down list for [product] that draws the name of the products from a
table called tbproducts. (one of the products is named "mixed")
a text box for the amount of pallets [N°Pallets]
a dropdown list of the types of [containers] that comes from a table called
tbcontainers.
a text box for the amount of units of trays [N°Trays] used only for mixed
pallets
a dropdown list of the configuration and the amount of individual trays on a
pallet [collie] (example is 64 trays of a certain size tray)this is drawn
from a table called tbcolllie
dropdownlist for the type of [carton]
then there are a number of text boxes that do calculations to determine the
total weight of the products ordered by the amount of pallets x the amount
of trays, x the weight that tray is designed to carry.


Normally each line shows one product something like this

Product pallets container trays collie carton
gross weight carton/tray weight pallet weight net weight
tomatoes 5 b2450 64 black
plastic 500 50 50
400


before I had all the names of the products in the same line and when the
user would choose mixed in the product list, I would have them put in each
field how many trays they wanted of each type of product. This does not work
as each product could conceivable be a different tray size.

So I need to have a way to put in the normal orders of full pallets of one
product as well as also be able to choose "mixed" by either selection Mixed
under the product list or by checking a box. the box would probably not work
as there may be more than one mixed pallet.

If I have a line for each item on the mixed I need a way to keep the all
together on one pallet

Product pallets container trays
collie carton gross weight carton/tray weight
pallet weight net weight
tomatoes 5 b2450
64 black plastic 500 50
50 400
Mixed 1
64 black plastic 500 50
50 400
(Mixed) tom b2450 20
(Mixed) pot b2451 20
(Mixed) spi b2450 24




I don't know if this helps or not...
michael


"Graham R Seach" ha scritto nel messaggio
...
Michael,

Well I don't know how you have your tables/forms set up. I presume the
main form represents the order, and the subforms represent the line items.
Your original question was about conditionally displaying subforms, but
has now morphed into a schematic issue.

As it's 12:15 AM here now, I'm off to bed, but don't worry, the beauty of
newsnet is that others will continue from this point. I'll be back in
about 8 or so hours, but by then you'll probably either have a good
solution or be well on the way.

To get the ball rolling, though, I suggest you step back a second, and
start by explaining exactly what it is you're trying to accomplish. Don't
assume we know anything about your business, so describe everything in
detail. We'll also need to know your current schema (tables, fields and
relationships), and a description of your current forms, including what
they connect to. I have a feeling we'll need to redesign some stuff to get
the job done.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks, but when they choose "Mixed" how can I tie the information to the
pallet? and is there a way to only show the sub sub form when it is
needed?

thanks


"Graham R Seach" ha scritto nel messaggio
...
Michael,

It all depends on where the data is going to. The report gets its data
from the table, not the form, so as long as you're storing the data to
an accessible place, it shouldn't be a problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks Graham
I am not sure how to set this all up. Now, Mixed is a choice under the
product list. What I was hoping to do is when they choose, mixed, I
could have them fill in another form and when I make my report. the
list would include something like the following

Product pallet count
tomatoes 2
mixed 1 5 tomatoes 2.5 kilos
6 carrots 1 kilo
10 Cabbage 1 kilo
potatoes 5
mixed 1 10 tomatoes 2.5 kilos
16 carrots 1 kilo
10 Cabbage 1 kilo

the mixed being done on the other form, but I can I keep them together?
Michael


"Graham R Seach" ha scritto nel
messaggio ...
Michael,

The subform is a control just like any other control, except it has a
SourceObject property. Just have your button's Click event code set
the subform's SourceObject property to the name of the form you want
to see in place of the other subform.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
I have a sub form to create an order. Most of the items in the form
are for a full pallet, sometime an order has a mixed pallet that has
many items some in different size containers on the same pallet.

I need to somehow show another form when the user chooses "mixed" on
the first form to record the content on this one pallet. There may be
many mixed pallets in an order.

thank you
Michael

Michael,

Sorry for taking so long. I had to think about your scenario for a while.

I think you need to reassess your schema before worrying about the user
interface, and here's what I came up with. I think you need 6 tables, as
shown below:

tblOrder
OrderID
Other stuff

tblOrderDetail
OrderDetailID
OrderID
Other stuff

tblProduct
ProductID
Other stuff

tblPallet
PalletID
Other stuff

tblTray
TrayID
PalletID
Other stuff

tblTrayProduct
TrayProductID
TrayID
ProductID

Here are the relationships:
One-to-many on tblOrder.OrderID -- tblOrderDetail.OrderID
One-to-many on tblOrderDetail.PalletID -- tblPallet.PalletID
One-to-many on tblOrderDetail.ProductID -- tblProduct.ProductID
One-to-many on tblPallet.PalletID -- tblTray.PalletID
One-to-many on tblTray.TrayID -- tblTrayProduct.TrayID
One-to-many on tblProduct.ProductID -- tblTrayProduct.ProductID

tblOrderDetail.ProductID will be null if a pallet is used.
tblOrderDetail.PalletID will be null if a discrete product is used.

On the UI, you should have two sections; one for discrete products, and one
for pallets.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
For the orders I have a order table and a orderdetail table. This is not
an ordinary business, what I mean by that is we don't have set product
names for each item we sell as the client decides how he wants the product
delivered, his choices include the product washed or un washed, if the
client wants it in a bag or in a plastic tray if in a tray the size of the
container from about 20 options. Then they choose the weight and they type
of pallet they want.

The following information is entered in the mail table,
[client] (from a drop down list drawn from the client table.)
[Destination] (from a drop down list drawn from the client table.)
[Del date] from a calendar
[TypeofPaller] from a list box
and other information such as the employees name and non important to this
question items

I have a subform that is drawn from a query of the tblorders and the
tblorder details

The following information is stored in the order detail

A drop down list for [product] that draws the name of the products from a
table called tbproducts. (one of the products is named "mixed")
a text box for the amount of pallets [N°Pallets]
a dropdown list of the types of [containers] that comes from a table
called tbcontainers.
a text box for the amount of units of trays [N°Trays] used only for mixed
pallets
a dropdown list of the configuration and the amount of individual trays on
a pallet [collie] (example is 64 trays of a certain size tray)this is
drawn from a table called tbcolllie
dropdownlist for the type of [carton]
then there are a number of text boxes that do calculations to determine
the total weight of the products ordered by the amount of pallets x the
amount of trays, x the weight that tray is designed to carry.


Normally each line shows one product something like this

Product pallets container trays collie carton
gross weight carton/tray weight pallet weight net weight
tomatoes 5 b2450 64 black
plastic 500 50 50
400


before I had all the names of the products in the same line and when the
user would choose mixed in the product list, I would have them put in
each field how many trays they wanted of each type of product. This does
not work as each product could conceivable be a different tray size.

So I need to have a way to put in the normal orders of full pallets of one
product as well as also be able to choose "mixed" by either selection
Mixed under the product list or by checking a box. the box would probably
not work as there may be more than one mixed pallet.

If I have a line for each item on the mixed I need a way to keep the all
together on one pallet

Product pallets container trays
collie carton gross weight carton/tray weight
pallet weight net weight
tomatoes 5 b2450 64 black
plastic 500 50 50 400
Mixed 1 64 black plastic 500
50 50 400
(Mixed) tom b2450 20
(Mixed) pot b2451 20
(Mixed) spi b2450 24




I don't know if this helps or not...
michael


"Graham R Seach" ha scritto nel messaggio
...
Michael,

Well I don't know how you have your tables/forms set up. I presume the
main form represents the order, and the subforms represent the line
items. Your original question was about conditionally displaying
subforms, but has now morphed into a schematic issue.

As it's 12:15 AM here now, I'm off to bed, but don't worry, the beauty of
newsnet is that others will continue from this point. I'll be back in
about 8 or so hours, but by then you'll probably either have a good
solution or be well on the way.

To get the ball rolling, though, I suggest you step back a second, and
start by explaining exactly what it is you're trying to accomplish. Don't
assume we know anything about your business, so describe everything in
detail. We'll also need to know your current schema (tables, fields and
relationships), and a description of your current forms, including what
they connect to. I have a feeling we'll need to redesign some stuff to
get the job done.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks, but when they choose "Mixed" how can I tie the information to
the pallet? and is there a way to only show the sub sub form when it is
needed?

thanks


"Graham R Seach" ha scritto nel
messaggio ...
Michael,

It all depends on where the data is going to. The report gets its data
from the table, not the form, so as long as you're storing the data to
an accessible place, it shouldn't be a problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks Graham
I am not sure how to set this all up. Now, Mixed is a choice under the
product list. What I was hoping to do is when they choose, mixed, I
could have them fill in another form and when I make my report. the
list would include something like the following

Product pallet count
tomatoes 2
mixed 1 5 tomatoes 2.5 kilos
6 carrots 1 kilo
10 Cabbage 1 kilo
potatoes 5
mixed 1 10 tomatoes 2.5 kilos
16 carrots 1 kilo
10 Cabbage 1 kilo

the mixed being done on the other form, but I can I keep them
together?
Michael


"Graham R Seach" ha scritto nel
messaggio ...
Michael,

The subform is a control just like any other control, except it has a
SourceObject property. Just have your button's Click event code set
the subform's SourceObject property to the name of the form you want
to see in place of the other subform.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
I have a sub form to create an order. Most of the items in the form
are for a full pallet, sometime an order has a mixed pallet that has
many items some in different size containers on the same pallet.

I need to somehow show another form when the user chooses "mixed" on
the first form to record the content on this one pallet. There may
be many mixed pallets in an order.

thank you
Michael

Thank you Graham, I will dig into it tomorrow and see if I can put it
together.. thank you for taking the time to sort it out
Michael

"Graham R Seach" ha scritto nel messaggio
...
Michael,

Sorry for taking so long. I had to think about your scenario for a while.

I think you need to reassess your schema before worrying about the user
interface, and here's what I came up with. I think you need 6 tables, as
shown below:

tblOrder
OrderID
Other stuff

tblOrderDetail
OrderDetailID
OrderID
Other stuff

tblProduct
ProductID
Other stuff

tblPallet
PalletID
Other stuff

tblTray
TrayID
PalletID
Other stuff

tblTrayProduct
TrayProductID
TrayID
ProductID

Here are the relationships:
One-to-many on tblOrder.OrderID -- tblOrderDetail.OrderID
One-to-many on tblOrderDetail.PalletID -- tblPallet.PalletID
One-to-many on tblOrderDetail.ProductID -- tblProduct.ProductID
One-to-many on tblPallet.PalletID -- tblTray.PalletID
One-to-many on tblTray.TrayID -- tblTrayProduct.TrayID
One-to-many on tblProduct.ProductID -- tblTrayProduct.ProductID

tblOrderDetail.ProductID will be null if a pallet is used.
tblOrderDetail.PalletID will be null if a discrete product is used.

On the UI, you should have two sections; one for discrete products, and
one for pallets.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
For the orders I have a order table and a orderdetail table. This is not
an ordinary business, what I mean by that is we don't have set product
names for each item we sell as the client decides how he wants the
product delivered, his choices include the product washed or un washed,
if the client wants it in a bag or in a plastic tray if in a tray the
size of the container from about 20 options. Then they choose the weight
and they type of pallet they want.

The following information is entered in the mail table,
[client] (from a drop down list drawn from the client table.)
[Destination] (from a drop down list drawn from the client table.)
[Del date] from a calendar
[TypeofPaller] from a list box
and other information such as the employees name and non important to
this question items

I have a subform that is drawn from a query of the tblorders and the
tblorder details

The following information is stored in the order detail

A drop down list for [product] that draws the name of the products from
a table called tbproducts. (one of the products is named "mixed")
a text box for the amount of pallets [N°Pallets]
a dropdown list of the types of [containers] that comes from a table
called tbcontainers.
a text box for the amount of units of trays [N°Trays] used only for mixed
pallets
a dropdown list of the configuration and the amount of individual trays
on a pallet [collie] (example is 64 trays of a certain size tray)this is
drawn from a table called tbcolllie
dropdownlist for the type of [carton]
then there are a number of text boxes that do calculations to determine
the total weight of the products ordered by the amount of pallets x the
amount of trays, x the weight that tray is designed to carry.


Normally each line shows one product something like this

Product pallets container trays collie
carton gross weight carton/tray weight pallet weight net weight
tomatoes 5 b2450 64
black plastic 500 50
50 400


before I had all the names of the products in the same line and when the
user would choose mixed in the product list, I would have them put in
each field how many trays they wanted of each type of product. This does
not work as each product could conceivable be a different tray size.

So I need to have a way to put in the normal orders of full pallets of
one product as well as also be able to choose "mixed" by either selection
Mixed under the product list or by checking a box. the box would probably
not work as there may be more than one mixed pallet.

If I have a line for each item on the mixed I need a way to keep the all
together on one pallet

Product pallets container trays
collie carton gross weight carton/tray weight
pallet weight net weight
tomatoes 5 b2450 64 black
plastic 500 50 50 400
Mixed 1 64 black plastic 500
50 50 400
(Mixed) tom b2450 20
(Mixed) pot b2451 20
(Mixed) spi b2450 24




I don't know if this helps or not...
michael


"Graham R Seach" ha scritto nel messaggio
...
Michael,

Well I don't know how you have your tables/forms set up. I presume the
main form represents the order, and the subforms represent the line
items. Your original question was about conditionally displaying
subforms, but has now morphed into a schematic issue.

As it's 12:15 AM here now, I'm off to bed, but don't worry, the beauty
of newsnet is that others will continue from this point. I'll be back in
about 8 or so hours, but by then you'll probably either have a good
solution or be well on the way.

To get the ball rolling, though, I suggest you step back a second, and
start by explaining exactly what it is you're trying to accomplish.
Don't assume we know anything about your business, so describe
everything in detail. We'll also need to know your current schema
(tables, fields and relationships), and a description of your current
forms, including what they connect to. I have a feeling we'll need to
redesign some stuff to get the job done.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks, but when they choose "Mixed" how can I tie the information to
the pallet? and is there a way to only show the sub sub form when it is
needed?

thanks


"Graham R Seach" ha scritto nel
messaggio ...
Michael,

It all depends on where the data is going to. The report gets its data
from the table, not the form, so as long as you're storing the data to
an accessible place, it shouldn't be a problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
Thanks Graham
I am not sure how to set this all up. Now, Mixed is a choice under
the product list. What I was hoping to do is when they choose, mixed,
I could have them fill in another form and when I make my report. the
list would include something like the following

Product pallet count
tomatoes 2
mixed 1 5 tomatoes 2.5 kilos
6 carrots 1 kilo
10 Cabbage 1 kilo
potatoes 5
mixed 1 10 tomatoes 2.5 kilos
16 carrots 1 kilo
10 Cabbage 1 kilo

the mixed being done on the other form, but I can I keep them
together?
Michael


"Graham R Seach" ha scritto nel
messaggio ...
Michael,

The subform is a control just like any other control, except it has
a SourceObject property. Just have your button's Click event code
set the subform's SourceObject property to the name of the form you
want to see in place of the other subform.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

"Michael" wrote in message
...
I have a sub form to create an order. Most of the items in the form
are for a full pallet, sometime an order has a mixed pallet that has
many items some in different size containers on the same pallet.

I need to somehow show another form when the user chooses "mixed"
on the first form to record the content on this one pallet. There
may be many mixed pallets in an order.

thank you
Michael