Subform Tab Control - copy 1 tab field 2 other

[naminder]

Hi

I have read through this forum and found some help on this but can't get it working.

I have a subform

Activity

Contains a tab control with two tabs

Activity Details - Persons

I want to copy the address field from Activity Details tab to the Address field on persons tab

Code for the on click even twon't work. Can't find errrors. I know it is because I haven't referenced it properly.

Me.txtpersonBuildingNameNo = Me.txtactivityBuildingNameNo

Any help

 

[ShaneMan]

Hey Naminder,

If this is on a subform, "I think" your going to need to reference the subform, so try:

Forms![FormName]![SubformName].Form![txtpersonBuildingNameNo] = Forms![FormName]![SubformName].Form![txtactivityBuildingNameNo]

HTH,
Shane

 

[naminder]

Hey Shane!!

Yeah it is on subforms - 3 levels actually!!!

Me.txtpersonBuildingNameNo = Forms![frm_OrganisationMaster]![frm_ServiceMain]![frm_Activity].Form![txtactivityBuildingNameNo]

i tried this but says can't find the field frm_Activity. But it is there???

 

[naminder]

Weird thing is, if i try reference the frm_ServiceMain it works fine. It's the third parameter!! maybe access doesn't go that far??