Application-defined or object-defined error

[dolfin13]

I get this error when invoking the click event from the subform.

This is the code in the click event.

Me.txtActivityID = Forms![Fmast_ContactTabs].Form.CSP_T_TeamActivityLog_ID
Forms![Fmast_ContactTabs].Form.subDetails.LinkChildFields = "txtActivityID"
Forms![Fmast_ContactTabs].Form.subDetails.LinkMasterFields = "CSP_T_TeamActivityLog.ID"

Any idea what's causing this?

 

[dolfin13]

I have found the solution to this problem, I should be more careful! Sorry for the waste of space.

 

[TheAceMan1]

How are ya dolfin13 . . . . .

A definite [blue]referencing problem[/blue] here. It appears you want to access [purple]master/child link properties[/purple] for a subform, from another subform . . . Is this correct!

If so . . . try:

[blue]Forms![purple][b]MainFormName[/b][/purple]![purple][b]subFormName[/b][/purple].LinkChildFields = "txtActivityID"
Forms![purple][b]MainFormName[/b][/purple]![purple][b]subFormName[/b][/purple].LinkMasterFields = "CSP_T_TeamActivityLog.ID"[/blue]

Be aware: [blue]a subform is a control like any other[/blue] . . . so it matters if you reference it as a control or a form! (the reason for [blue].Form[/blue] to reference as a form).

The [blue]Master/Child Link properties[/blue] are available on the control . . . not the form!

See Ya! . . . . . .