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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <gseach@xxxxxxxxxxxxxxxxxxxxxx> ha scritto nel messaggio
news:%23Q0VLeZ%23FHA.740@xxxxxxxxxxxxxxxxxxxxxxx
> 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" <michaelNOSPAM@xxxxxxxxxxxxx> wrote in message
> news:%239AE3YZ%23FHA.2676@xxxxxxxxxxxxxxxxxxxxxxx
>> 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" <gseach@xxxxxxxxxxxxxxxxxxxxxx> ha scritto nel messaggio
>> news:u43Eb7Y%23FHA.740@xxxxxxxxxxxxxxxxxxxxxxx
>>> 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" <michaelNOSPAM@xxxxxxxxxxxxx> wrote in message
>>> news:ud2feuY%23FHA.2040@xxxxxxxxxxxxxxxxxxxxxxx
>>>>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
>>>>
>>>
>>>
>>
>>
>
>


.

Quantcast