subform and recordset

[jamest85]

Hi:
I have a subform, and I have a recordset which contains data in it, now I want to populate the recordset data into subform, how can I do it, I have tried:

Me.subformDetails.Form.RecordSource = rst
or:
Me.subformDetails.From.recordSet = rst

All do not work.

Thanks in advance.

JT

 

[CyberLynx]

You can save yourself the step of creating the recordset. Whatever query you used to create the Recordset, drop it directly into the Record Source of the SubForm:

Me.MySubForm.Form RecordSource = "SELECT * FROM MyTable WHERE Whatever = Whatever;"

.