Searching Subdatasheets

[Stonez]

Using Access 2000 I have inserted a subdatasheet into a query to display a 1 to many relationship between parent and child records. The query only contains a Contacts table with ContactID, Name, Address etc. The Subdatasheet contains a Locations table with ContactID, and the many Location(s) a contact could have. Link child and master fields are on the ContactID. I am able to filter on all the values in the query grid that contain the Contact fields , however, I cannot filter on the subdatasheet Location values. Is there an easy way to do this without using Joins or Unions in the underlying Sql? If not, how can this be done?

 

[tlbroadbent]

Could you post your query please? Open the SQL View in the Access query designer, copy the SQL code and paste here.

Thanks, Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Stonez]

SELECT tblContacts.[Contact ID], tblContacts.[Last-First Name], tblContacts.[Address 1], tblContacts.[Address 2], tblContacts.City, tblContacts.State, tblContacts.[Zip Code]
FROM tblContacts;


Note:
I have noticed that subdatasheet code does not appear here?
To insert the datasheet I open this query and use the Insert, Datasheet, options and select the tblLocations table linking child and master fields to Contact Id. The datasheet works great but I cannot search on the datasheet values...