Quote:
>Hello
>I have made Form containing one subform based on Table. How can I change
>subform source of records. I have tried to update subform RecordSource by
>opening Subform :
>DoCmd.OpenForm ("subform")
>Forms!subform.RecordSource = sqltekst
A subform is not really an "open" form. If it's visible
within the main report, then the main form can refer to it
like this:
Me.subformcontrolname.Form.RecordSource = sqltekst
--
Marsh
MVP [MS Access]
Subform update