Populate a datasheet and extraction of data from datasheet

[Savita]

Hi,

There is a requirement for
1)Populating a datasheet in a subform with a querystring which is dynamically built in VBA.This querystring is constructed based on the search criteria fields selected by the user in the main form.How can this be immplemented?

2_To click/double click a record in the datasheet,extract data and populate textfields,comboboxes with it which are in the main form.How is this achieved?Also,I can't find click events in a datasheet.

Pls let me know.
Thanks,
Savita

 

[pbaldy]

The sample db in this FAQ would appear to do exactly what you want:

http://www.mdbmakers.com/forums/showthread.php?t=4895

 

[Savita]

Thanks for sending the link.As per the example given in the link,I used the following code in the form_load() event to populate the subform(Child0) and display records in the datasheet view.
Me.Child0.Form.Recordsource=strSql (strSql is a query string which has a join on 2 tables)
But I got the following error,"The expression you entered refers to an object that is closed or does not exist".Pls let me know the solution for this.

2)How can I extract data from the subform in datasheet view on double clicking a record?I want to populate textfields and comboboxes with this data.

Savita