Query Subform Criteria

[Costefran]

Can anyone help with the following

I have creat a query that relies on the value of a subform control as criteria

The subform called 'selection' has a control called 'ID' and the query criteria goes something like

Select [All Table].[ID] where [All Table].[ID] = Forms![selection].[ID]

Unfortunately there are more than one record in the subform so , for example, ID may have two values say 50 and 51

but when I run the query I only get the first record

Is there anyway I can force the query to utilise all values under the subform control so that I retrieve all records
so the result would be 50 and 51

Thanks

 

[nim180]

Is ID a dropdown box you choose from to bring up the records related to it. If so you can just place this on your mainform and place the subform in datasheet view,this way all the records will show up on your subform.

you could always just go to form properties and click record selector to yes. That way you can click to next record.

Hope that helps,
Nim

 

[Costefran]

Many thanks