subdatasheet in a subform

[Guest]

I inserted a subdatasheet in a query, that was based on another query. With
the UniqueRecords property set to "yes", it shows the correct records.

When I insert the same subdatasheet into a subform, it yields all records in
the query, and does not differentiate unique records based on 3 fields:
ProjectName, BidNumber, ItemNumber.

Any help is appreciated!

 

[Gina]

Could it be that you do not link the subform with the main form ??
Gina

 

[John Vinson]

I inserted a subdatasheet in a query, that was based on another query. With
the UniqueRecords property set to "yes", it shows the correct records.

When I insert the same subdatasheet into a subform, it yields all records in
the query, and does not differentiate unique records based on 3 fields:
ProjectName, BidNumber, ItemNumber.

Any help is appreciated!

A subdatasheet *is a display tool*. It isn't data; you cannot base a
subform on a subdatasheet, instead you base a subform on a Table or
(better) on a Query. This Query would reference the same table that
your subdatasheet is referencing.

John W. Vinson[MVP]