Getting the name of a subform 1

[zevw]

I have a record selected in a subform and I click on delete in the parent form

I know I can do Form![Parentform]![Subform].subform

How can I get the name of the subform with Me.Name

Me.Name gives me the parent form name not the subform name

 

[PHV]

Did you try this ?
Me![subform control].Form.Name

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

Or perhaps this:
Screen.PreviousControl.Parent.Name

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[zevw]

Thanks!

Since it was in tab control it was giving me the name of the Tab.

So I used

FrmName = Screen.PreviousControl.Form.Name

 

[zevw]

How do I now combine the variable with this string

WrdNum = "Forms!ReviewForm!" & FrmName & ".Form.WordId"

doesn't work its a string

WrdNum = Forms!ReviewForm![FrmName].Form.WordId

It doesn't recognize FrmName as a variable?

 

[PHV]

I'd try this:
WrdNum = Eval("Forms!ReviewForm!" & FrmName & ".Form!WordId")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[zevw]

Works great!