Highlighting textfields of a subform

[nerd19]

hi, I have a form that allows a sort of dynamic filtering of a subforms recordset. On the main form i have various options to filter results that are displayed on the subform these options are things like part numbers, dates, employees, etc. What happens when options are selected off the main form is an sql string is created to the according options and a record set is then created and as set to the subforms recordset. what i want to do, and am having trouble with is this... there is a text box within the subform that shows the 'number of days' since that record was last updated (calculated using datediff), if 'the number of days' is over a specified limit, i.e. a value from a text box on the main form, highlight or change the backcolor of all records whose 'number of days' is beyond the specified limit. The view of the subform is a continious form if it makes a difference.

i appreciate the feedback,
n.e.r.d.

 

[PHV]

Have you tried Conditional Formatting ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[nerd19]

thanks that worked, i didnt know it had such an option