updating the recordset of an embedded form

[ds2728]

Hello,

I have form1 which has a subform (form2). in form2 code for form_open I am setting the recordset to a sql query that attaches to a sql server.

When I open form1, form2 loads as the sub form great and I have data. what i can not find how to do is update or change the recordset of form2 after the form has been opened.

I want to be able to change the data in the subform when user selects option on form1. I can do: "form_form2.requery", but I need to perform: "set form_form2.recordset = sqlstr"

Any help would be appreciated

Thanks

 

[Remou]

That would go:

Forms!FormName!SubformControlname!Form.RecordSource
Or
Me!SubformControlname!Form.RecordSource

You may wish to read

http://www.mvps.org/access/forms/frm0031.htm

 

[ds2728]

Thanks for the response and the web link.

The following did the trick.

Set Me!Form1.Form.Recordset = GBL_rst


Thanks again....