[AccessD] Conditional Formatting

[Rocky Smolin]

Dear list(s)

I have a text box with an asterisk in it on a continuous form.  When the
user clicks the box a modal/ pop-up form opens and the user can enter a
comment in a memo field which is linked to the parent recordset by PK/FK.

I have conditional formatting set so that if there is a comment for that
particular record the backcolor of the asterisk box turns red - if no
record the backcolor is white.  This is so the user can see which records
on the form have comments attached to them.

This works fine when I open the parent form - the asterisk box for all the
records which have comments are backgrounded red, those without comments
are white.

The problem is that when I add a comment to a record that didn't have one
the asterisk box does not turn red when the modal/popup form closes.  And
when I delete the comment so that the record has no comment, the background
color of the asterisk box does not turn from red to white.

Exiting the form and re-entering it again show the right conditions for
each record on the form.

So the conditional formatting is not being triggered except when the form
opens.  I have tried requery, refresh, and repaint but no cigar.

*Does anyone know how to refresh the conditional formatting of fields on a
form while it's open?*

MTIA

Rockty