Nested Subform???

[Guest]

Hi Again
I am using s tab page and i am having problems trying to display 2
different recrords on the same page.
I have a table which shows what type of services each of our two vehicles
has. One of them has one type and the other has three.
Is there anyway i can show the different types of services for the second
one on the same page?
I did try a query but it duplicated all the info for the second one.
Sorry i know this is not explained very well. I can send you a screen shot
if it would help. Thanks again.

 

[Ed Robichaud]

If a vehicle can have both types of services, then you could use 2 different
subform, displayed on the same or separate tabs. If vehicles can only have
one or the other service, then you could still use two different subform,
set which one to display by using code to check for the appropriate value
(or use 1 subform, but set the recordsource by code after checking for the
appropriate value).
-Ed

 

[Guest]

Hi
Thanks very much for that. I Dont suppose you could explain it in a little
bit more detail please, it would be much appreciated.
Thanks again
Angel_1