When a Field is populated through code, as in
A = B + C
most of Field A's events, such as the AfterUpdate event, do not execute! These events will only execute if Field A is physically populated, i.e. through data entered through the keyboard, being pasted into the Control holding the Field, or through it being entered using a scanner.
If the Value is entered through code, the secondary Field will also have to be populated, through code, at the same time and from the same place in code, something like:
A = B + C
If A > 10, Then D = "KK1"
If A > 7 And A < 11 Then D = "KK2"
This assumes you're talking about whole numbers only. If you're talking about numbers with fractions, you'll need to adjust the code slightly, but you should get the idea.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007