Change background color on click

[ilanray]

Hi
I have a continuous forms with some data which mea, ii display all data I have at the details
the data is (id, detail and date
i would like to click on one of the record and mark it or change the background
can someone please help me with that

 

[theDBguy]

One approach is to add a Yes/No field to the table. It will show up as a checbox on the continuous form that you can use to mark each record.

 

[MajP]

Easiest is to put a hidden textbox in the header.
1. Call it txtLink
2. in the forms current event set the primary key. Lets assume it is called ID
me.txtLink = me.ID
3. set the condition format to something like
expression: [id] = [txtLink]

 

[Mike Krailo]

If you like to watch a video explanation of MajP's solution: Highlight Selected Row