J
jlieffort via AccessMonster.com
I have a form with some with some code highlighting different text boxes if
the numbers displayed meet certain criteria. Like if this field in the footer
is less than this field ( in the footer) then shade the two text boxes in
yellow.
The information aggregates in the footer and I compare values there. The
problem is when I apply a filter to the records the data display aggregated
in the footer the (on current) commands will not execute until I incremented
the record one time. If there in only one record that meets the filter
criteria, my control formats don't display. Am I using the wrong event (On
Current) to execute the code or .......please help
the numbers displayed meet certain criteria. Like if this field in the footer
is less than this field ( in the footer) then shade the two text boxes in
yellow.
The information aggregates in the footer and I compare values there. The
problem is when I apply a filter to the records the data display aggregated
in the footer the (on current) commands will not execute until I incremented
the record one time. If there in only one record that meets the filter
criteria, my control formats don't display. Am I using the wrong event (On
Current) to execute the code or .......please help