VBA

[daniel.sutcliffe]

Hello,

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!?!

 

[John Vinson]

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.

Use the Form's Current event. It fires when the user navigates to (or
creates) a new record.