Conditional Formatting Based on Visible Value

[BrianB75]

I might be biting off more than I can chew but here goes. I have a form where the Detail displays a list of records with some basic data and the Form Header lists more detailed information for the record that is selected in the Detail. What I would like to do is format the Detail fields so that only the record displayed in the Header is highlighted (Bolded and fore color changed). I tried a straight conditional format to say [veh_no] (Header field) = [veh_no_list] (Detail field) but is formats all the Detail records since the form is pulling against the same query.

What I tried to do, but could not figure out, was to set the condition on the Detail record based on what is Visible in the Header. This didn't work out as expected.

Please let me know if anyone can help or if I need to try and explain this further.

Thanks in advance!

 

[BrianB75]

Just as a follow-up I tried the set value but that did not seem to work.