link child fields

[djam]

Anyone know the code in vb to set the linkchildfields and linkmasterfields property??

thanks

 

[PWise]

me.subformename.LinkChildFields="childfieldname"
me.subformename.LinkmasterFields="masterfieldname"

 

[Darrylles]

Hi,

Can't see this working.

If it does, please respond with a post.

Regards,

Darrylles "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." AND "A pointer to a solution is better than the solution - you'll remember the solution via a pointer". darrylles@totalise.co.uk

 

[PWise]

it works try requerying form ect.
i just tried it

 

[BillPower]

Hi pwise,

Your code works perfectly, this pedantry is catching. Why not, if the SourceObject is likely to be variable, add:

me.subformename.SourceObject="sourceobjectname"

before linking the child and master fields.

 

[PWise]

have done that before with excellent results

 

[Darrylles]

Hi,

Glad it does work.

Why then, when referring to controls on subforms do you need to use 'subform!form.control'?

I've always found it difficult to remember this syntax.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." AND "A pointer to a solution is better than the solution - you'll remember the solution via a pointer". darrylles@totalise.co.uk

 

[PWise]

i have found that refering to forms!formname.controlname works only sometimes if that is what you want to refer to
dont know why
that is if you want to refer by forms!formname.controlname
i dont know exactly how you want to refer by

 

[djam]

this is what I tried and it didn't work,

Me.mainform.LinkChildFields = "id"
Me.mainform_sub.LinkMasterFields = "id"

the error says that the method or data member is not found(just after the Me. it is highlighted) "so many events, so little time"

 

[PWise]

Me.mainform.LinkChildFields = "id"
Me.mainform_sub.LinkMasterFields = "id"
Won’t work because LinkChildFields & LinkMasterFields are properties of the subform control
I should have written
me.subformcontrolname.LinkChildFields="childfieldname"
me.subformcontrolname.LinkmasterFields="masterfieldname"
'subform!form.control
Refers to the form embedded in subform control