subdatasheet in a subform

K

Kevin

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!
 
J

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!
Click to expand...

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]
 
Top