Conditional Formatting and Refresh / Requery

>Hello,
>I have conditional formatting set up on a subform based on a calculated
>value in the underlying query. For instance, if Sales are >$1000, the
>query displays "Yes," otherwise it displays "No." The conditional
>formatting is set up to read the 'Yes' or 'No' value and color the text
>accordingly.
>
>I have an event in the subform that allows users to update the sales.
>It actually runs an update query behind the scenes. What I want to
>happen is for the formatting to pick up the value immediately and
>change color. I can requery the subform, but that loses my place in the
>form. And refresh doesn't seem to trigger the conditional formatting to
>check for the values.
>
>Is there any way to refresh conditional formatting on the fly?

It sounds like the subform isn't refreshing after an update in the main form.
Is this the behavior that you're trying to achieve? It's not clear how
you've implemented this; you should be able to requery the subform without
affecting your main form (Me.SubForm.Requery). Also, have you tried to
requery the control directly? For example, using an AfterUpdate event from
the main form, do something like:
>
Me.SubForm!Sales.Requery
>
>
midlothian@gmail.com wrote:>
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

>The subform is not connected to the main form. It's just a set of
>records. That's why I use the update query to update those records.
>The requery and refresh actions I've used are fired 'After Update.'
>>[quoted text clipped - 24 lines]

I have conditional formatting set up on a subform based on a calculated
value in the underlying query. For instance, if Sales are >$1000, the
query displays "Yes," otherwise it displays "No." The conditional
formatting is set up to read the 'Yes' or 'No' value and color the text
accordingly.
>
I have an event in the subform that allows users to update the sales.
It actually runs an update query behind the scenes. What I want to
happen is for the formatting to pick up the value immediately and
change color. I can requery the subform, but that loses my place in the
form. And refresh doesn't seem to trigger the conditional formatting to
check for the values.
>
Is there any way to refresh conditional formatting on the fly?
>