Auto fill data based on other data entered in the same form

[drnurulsyakirin]

Hi All!

I have a field (field A) in a form that is based on calculation of field B + field C. I wanted another field (field D) to auto enter a description based on field A result.
E.g.
if field A > 10, then field D = KK1
if field A = 8-10, then field D = KK2

I tried these:
Private Sub A_AfterUpdate()


If [A] > 10 Then
[D] = "KK 1"
If [A] = 8 - 10 Then
[D] = "KK 2"


End Sub

Tested it but no changes happened to field D...

Kindly help, thanks!

[SoftwareMatters]

Try this (also make sure the fields are formatted as numbers)

If Me![A] > 10 Then
Me![D] = "KK 1"
ElseIf Me![A] >= 8 and Me![A] <= 10 Then
Me![D] = "KK 2"
End if

[Missinglinq]

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)>