Setting Focus on a particular record in a continous form

[Guest]

Hi:

I have a continous form (7 records) which consists of a txtbox and cmdbutton
aligned horizontally, hence each record is represented by a txtbox and a
cmdbutton. If i click the cmdbutton it opens a new form. I wanted to add
distinguishing feature which highlight the txtbox of that particular record
only. Thanks.

 

[Marshall Barton]

I have a continous form (7 records) which consists of a txtbox and cmdbutton
aligned horizontally, hence each record is represented by a txtbox and a
cmdbutton. If i click the cmdbutton it opens a new form. I wanted to add
distinguishing feature which highlight the txtbox of that particular record
only.

You can use conditional formatting on the text box to make
it look different.

Add a hidden text box to the form's header section. Then
use the code in the command button's click event to set the
hidden text box to the current record's key field. CF can
then use that hidden text box in its condition. Turning off
the highlight is just a matter of setting the hidden text
box's value to Null.