Subforms recordsource

[Pekka]

Hi,
i'm trying to change the form's subform's source object and populate the data by selected criteria.
with this, i get the error message that the form cannot be found and it's and it even bring the form as subform with no recordsource.
Forms!up_tulov_f.RecordSource = tiet2
Forms!haku!vir_sub.SourceObject = "up_tulov_f"
i'vtried to chanfe the order with the statement but no help.
Best regards

Pekka

"every dog will have his day"

 

[KenReay]

Hi

You are doing this in the main form?

Try something like

Me.SubFormCONTROLName.FORM.RecordSource = "..whatever"

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Pekka]

Thanks Ken. I missed that it be can referred to subform with Form.

Pekka

"every dog will have his day"