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
---------------------------
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" <
[email protected]> 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
---------------------------
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" <
[email protected]> 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
---------------------------
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