Can I highlight a record?

[Anthony]

I have a CD Db, on one form it shows the complete CD details, on another continous form it shows a list of all tracks for all CDs, each track has a CmdButton linking it to the relevant Cd. I use the track listings for several purposes including tracksearch. What I want is for the track to be highlighted when I go to the CD form.
Any suggestiuons??

Thanks
Michael

 

[Matthew Snook]

You could create a hidden flag field of some kind. So in the click event, just before taking you to the CD form, a yes/no value for the track (Me!TrackSelected or something) is given the "yes" value. Now on your form, any track with the "yes" value is highlighted. Then other operations can change the value back to "no" when that's appropriate.

Matt

 

[Atomic Shrimp]

Have a look at this topic; my conditional formatting demo can probably be adapted to fit your needs, all you need to do is make the condition based on a hidden field (as Matthew suggests) and set only the value in the relevant row to such that it switches on the formatting.