Continuous form with two separate detail sections?

[Sqt_Squirrel]

Hi, Can anyone help??......



I have a form which needs to have two continuous lists from the main
datasource, each of them from seperate filters; the first filter will need
to do a count of records where an entity has an attribute of a date that has
passed; the second filter will list all the records for the entity..... any
ideas?





Squirrel.

 

[Allen Browne]

Place both subforms directly on the main form. Set the Link Master Fields of
the 2nd subform to the name of the relevant field in the other subform, such
as:
[sub2].Form!Text2
where sub2 is the name of the other subform, and Text2 is the text box on
that form.

There's an example of this in the old Northwind sample database: the
Customer Orders form has one subform where you pick an order, and a 2nd
subform that shows the details of that order.