Conditional Formatting subForm

[Guest]

I have a form based on a table to scan in ID #s as students appear. I also
have a subForm based on a query that counts the number of times their ID is
scanned.

I set the conditional formatting to alert the user as to when their ID is
scanned too many times. 3 series
<=5 (Green Background)
Between 5 and 8 (Yellow Background)

=8 (Red Background)

The count is correct, but the color in the background only appears when I
click on the subForm. I'm guessing I need to activate the subForm to make
the background color appear. How do I activate the subForm in the
AfterUpdate or OnDirty Event from the textbox LocID?

 

[Marshall Barton]

I have a form based on a table to scan in ID #s as students appear. I also
have a subForm based on a query that counts the number of times their ID is
scanned.

I set the conditional formatting to alert the user as to when their ID is
scanned too many times. 3 series
<=5 (Green Background)
Between 5 and 8 (Yellow Background)

The count is correct, but the color in the background only appears when I
click on the subForm. I'm guessing I need to activate the subForm to make
the background color appear. How do I activate the subForm in the
AfterUpdate or OnDirty Event from the textbox LocID?

First try using:

Me.subformcontrol.Form.Repaint

If that doesn't take care of it, try using:

Me.subformcontrol.SetFocus
Me.subformcontrol.Form.SetFocus

 

[Guest]

Worked perfect! Thanks Marshall
--

Rip

First try using:

Me.subformcontrol.Form.Repaint

If that doesn't take care of it, try using:

Me.subformcontrol.SetFocus
Me.subformcontrol.Form.SetFocus