Conditional Formatting subForm

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
Click to expand...

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?
 
Ripper said:
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?
Click to expand...


First try using:

Me.subformcontrol.Form.Repaint

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

Me.subformcontrol.SetFocus
Me.subformcontrol.Form.SetFocus
 
Worked perfect! Thanks Marshall
--

Rip


Marshall Barton said:
First try using:

Me.subformcontrol.Form.Repaint

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

Me.subformcontrol.SetFocus
Me.subformcontrol.Form.SetFocus
Click to expand...
 
Back
Top