Explicitly Reference Control on Continuous Subform

[taicho]

Hi All!

Quick question:

If I have a continuous subform with and I had a control (textbox) named "myTxt" how would I refer to the "myTxt" control in x record on the continuous subform... i.e.

Record 1> [Date] [Something] [myTxt]
Record 2> [Date] [Something] [myTxt]
Record 3> [Date] [Something] [myTxt]
Record 4> [Date] [Something] [myTxt]<--- Only want to modify "SpecialEffect" property for this object.

Referencing the property affects all the controls of the name "myTxt" in all the records in the continuous subform whereas I only wish to apply the property to the one I click on for instance...any ideas? Much appreciated...

 

[MarkK]

This is not possible. Look at your continuous subform in design view: There is actually only one textbox name 'myTxt'. If you change a property of this single control it, well, changes. Everywhere.

 

[pbaldy]

I agree, and I'd add that depending on what you're trying to accomplish, Conditional Formatting may be the answer.

 

[RuralGuy]

When you click on a record in a continuous form, that record becomes the Current record and referencing the SubForm *will* reference the Current record as well.