reference the subform in VBA code

[hengsin]

Anyone here know what is the syntax in VBA code to refer to the subform. For example:

MainForm: frmMeeting
Subform: subfrmAction
field which to refer: Action ID in subFormAction

If is in mainform, i know it's Me!ActionID. But how about the subform?

 

[ToeShot]

I believe what is below will work

Me!SubForm!ActionID

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[hengsin]

thanks but your method was not working

 

[TonyJollans]

Hi hengsin,

Try Me!subfrmAction!ActionID

but make the sure the name in red is the name of your subform control if it is different from the name of the subform.

Enjoy,
Tony