access data from sub query using values from main query

[ramesh_ndyd]

so how can i go about it shoul i use adodb recordset to set the sourceobject willit work in that case as my sub form is dynamic based on the values of the above combo's in the form

[June7]

No, I said the SourceObject must be a saved Access object (table, query, form, report). Then you can set a filter for the object. A form object will be best for this.

Actually, I don't think you really need a subform. Check out tutorials at http://datapigtechnologies.com/AccessMain.htm especially Build a Custom Filter in Your Form in the Access Forms: Tips & Techniques section

[ramesh_ndyd]

thanks, got it to work with the example.

One doubt i added the combo to the form header and the query part to the details section. How to display the data in tabular format for the details section as it will be containing around 20 record for each selection from combo

[June7]

You can use Continuous Form view and arrange the controls to look like Datasheet. Otherwise would have to be form/subform and the subform would be in Datasheet view.

[ramesh_ndyd]

thanks for the solution