Subform Recordsource 1

[georgp]

Help wanted!
Today is obviously not my day....
I'd like to set the recordsource of the subform frm_CustOpporSub3 in the VBA code of the mainform frm_CustOppor:

Forms!frm_CustOppor!frm_CustOppor3.Recordsource = frm_CustOppor.Recordsource

I also tried other variations. Always error messages - either the object does not support the method, type mismatch or whatever.

I hope, someone can help me before I go home...

Thanks in advance, georgp

 

[FancyPrairie]

Try this syntax

Forms!frm_CustOppor!frm_CustOppor3.form.Recordsource = frm_CustOppor.Recordsource

 

[georgp]

Thanks Fancy Prarie,

ACCESS's comment is: Can't find the field 'frm_CustOppor3' referred to in your expression. Tried the same by using

Forms!frm_CustOppor.frm_CustOppor3.form.Recordsource = Me.Recordsource

instead of your suggestion

Forms!frm_CustOppor!frm_CustOppor3.form.Recordsource = Me.Recordsource

but also no luck: Application defined or object-defined error.

I continue to try, but if you have identified the point, please let me know.

Thanks again, georgp

 

[FancyPrairie]

Syntax should look like this:

Forms!MainFormName!SubformControlName.Form.RecordSource = Whatever

 

[georgp]

FancyPrairie,

you were right the first time. Sorry to have bothered you again. Some typo from my side. Enjoy the star...

georgp