I think the question is probably more complicated than the answer so here goes......
I have a main form with a subform, based on a main table and linked table.
I have made a query based on the main form to only select certain records and also made a form based on this query to show in continuous view so I can quickly view these records without previewing a report.....great so far.
But..... I also want to show in my new form the associated records from the linked table on this form, below or next to the record of the main table.
I have tried using more subforms within the new form but cannot use subforms in "continuous" form view.
Am I missing the point here or trying to overcomplicate matters. Is there an easy answer?
thanks
I have a main form with a subform, based on a main table and linked table.
I have made a query based on the main form to only select certain records and also made a form based on this query to show in continuous view so I can quickly view these records without previewing a report.....great so far.
But..... I also want to show in my new form the associated records from the linked table on this form, below or next to the record of the main table.
I have tried using more subforms within the new form but cannot use subforms in "continuous" form view.
Am I missing the point here or trying to overcomplicate matters. Is there an easy answer?
thanks