Use a macro to change subfrom sourceobject? (1 Viewer)

[nickbarnes]

Hello again everyone,

Thanks to everyone for their help so far with getting my DB working and on SP2010. Unfortunately I've got another issue I need your help with!

My main form "ExchangeView" contains a subform "PCPList", the source object for "PCPList" needs to change depending on the "Phase" field from the main form. Once the source object has changed, I then need to set the Master/Child link to the "UID" field.

That doesnt explain it very well but hopefully this will:

ExchangeView On current event:

If ExchangeView.Phase = "1" then change PCPList.sourceobject to the form "P1PCPs" and set the Master/Child link to "UID"

Else If ExchangeView.Phase = "2" then change PCPList.sourceobject to the form "P2PCPs" and set the Master/Child link to "UID"

and so on for a total of 15 different phases.

I can only use web compatible macros though becuase the DB will eventually be published on SharePoint.

Can anyone help me with this please?

Many thanks,

Nick