Me("txtTextBox" & i).Value <--- this style?

D

David Mueller

[short version] I need ... [Subform Control Name].Form![Control
Name].Property ... but I need to put it together on-the-fly

Any thoughts?



[Long version] I'm in a situation where I'm reading subform, control names,
and properties from a table, and I want to enable/disable them from code. I
don't know how to reference them. I've tried several styles like that of the
subject line, but I'm striking out.
 
K

Klatuu

You can reference objects like this by using the collection property of the
object and passing it's name. For example:
Me!MySubForm.Controls("NameOfControl").Properties("NameOfProperty")
 
R

RoyVidar

David Mueller wrote in message
[short version] I need ... [Subform Control Name].Form![Control
Name].Property ... but I need to put it together on-the-fly

Any thoughts?



[Long version] I'm in a situation where I'm reading subform, control names,
and properties from a table, and I want to enable/disable them from code. I
don't know how to reference them. I've tried several styles like that of the
subject line, but I'm striking out.
Click to expand...

I think you can play with similar as you're using in the subject of
this
thread, here are a couple of attempts

me.controls("SubformControl
Name").Form.controls("ControlName").Property

me("SubformControl Name").Form("ControlName").Property

strFormName = rs.fields("subformcontrolname").value
strControlName = rs.fields("controlname").value
me.controls(strFormName).Form.controls(strControlName).Property

me.controls(rs.fields("subformcontrolname").value).Form.controls(rs.fields("controlname").value).Property
 
Top