Visible for Current Record

[CJ]

Hi Groupies

I have a subform that is set as continuous, the Employee ID field is set to
not visible.

What I would like is that when a user clicks on a name field for one of the
subform records, the corresponding Employee ID becomes visible but only for
that one record. When the focus moves to a different record the ID becomes
invisible again and visible on the record that now has the focus.

I have been able to make the ID field show up for all of the records in the
subform but not just the one I am on.

 

[Guest]

You can't do that, changing the property of the text box in a continues
subform will change it for all the records, unless you use the Conditional
Formatting (but that not what you want to do)

Another option:
Create a text box in the main form to display the Employee ID, use the sub
form OnCurrent event to set the value

Me.Parent.[TextBoxName] = Me.[Employee ID]

That way you have the text box apear once without setting the visible property
(Just an idea)

 

[CJ]

Well that is a major drag........

Thanks for the response and suggestion Ofer.
CJ

You can't do that, changing the property of the text box in a continues
subform will change it for all the records, unless you use the Conditional
Formatting (but that not what you want to do)

Another option:
Create a text box in the main form to display the Employee ID, use the sub
form OnCurrent event to set the value

Me.Parent.[TextBoxName] = Me.[Employee ID]

That way you have the text box apear once without setting the visible
property
(Just an idea)
--
Good Luck
BS"D

Hi Groupies

I have a subform that is set as continuous, the Employee ID field is set
to
not visible.

What I would like is that when a user clicks on a name field for one of
the
subform records, the corresponding Employee ID becomes visible but only
for
that one record. When the focus moves to a different record the ID
becomes
invisible again and visible on the record that now has the focus.

I have been able to make the ID field show up for all of the records in
the
subform but not just the one I am on.