labels - event procedures

[Dan]

I'm new to VBA. I have designed a database that has on
one of it's forms a combo box with values ranging from 1-
21, and I havelabels beside the box that become visible
when the user enters a value so for a value between 1-7
the label becomes visible and the caption is"Normal", 8-
14 the caption is "borderline". However I notice that
when I click on to next record the labels remain visible
with and when I change the values in the combo box to the
new values for the new record and then go back to my
previous record the labels stay the same so they do not
reflect the vlaues in the combo box. Is there a way to
get round this so when I click on new record the labels
become inivisible and when you do enter a value stay the
same when you go back to that record. I have put the
event procedure on After Update, but have tried the
others as well. Can anybody help!?!

 

[Rick Brandt]

I'm new to VBA. I have designed a database that has on
one of it's forms a combo box with values ranging from 1-
21, and I havelabels beside the box that become visible
when the user enters a value so for a value between 1-7
the label becomes visible and the caption is"Normal", 8-
14 the caption is "borderline". However I notice that
when I click on to next record the labels remain visible
with and when I change the values in the combo box to the
new values for the new record and then go back to my
previous record the labels stay the same so they do not
reflect the vlaues in the combo box. Is there a way to
get round this so when I click on new record the labels
become inivisible and when you do enter a value stay the
same when you go back to that record. I have put the
event procedure on After Update, but have tried the
others as well. Can anybody help!?!

A label has no "per-record" value. It is just a static object sitting on
your screen. Any time you need its caption to change *you* must include
some code to make it happen.

Just make a call to your Combo's AfterUpdate event in the Form's Current
event. That is the event that fires every time you change records.