updatable query or use different parameter?

[Drenda]

Can anyone help

I am currently using the results of a subform control as a parameter for a query. The subform (being shown as a datasheet) typically shows more than one record but the output results of my query are restricted as only the first record of the subform is seen. I have tried using the underlying table / query of the subform and get the right results but the query is no updatavle. Is there any way to

1) Ensure that my parameter considers a particular value on all records in my subform or is there another way

Thanks

 

[Remou]

Have you tried using the underlying table with NOT IN?


SELECT ID, Data FROM tblT WHERE ID NOT IN
(SELECT ID FROM NameOfUnderlying_Query)

 

[Drenda]

Thanks

I will give this a go and let you know how I get on