Auto fill a field based on seperate field 1

[madrappin]

I am trying to find a way to automatically show the grade if the score is entered.

So the fields name is SCORE and say if it is a number 0-24 it a field named GRADE will say "Fail" and 25-35 will say "D", so on and so forth. Any help would be appreciated. Thanks.

 

[randy700]

How about...
Select Case Score
Case <25:
Grade = "Fail"
Case <36:
Grade = "D"
Case <50:
Grade = "C"
Case Else:
Grade = "Pass"
End Select


Randy

 

[madrappin]

What is Case? I am a little confused by that whole statement. If you could please explain more. Thanks.

 

[randy700]

The Select Case statement evaluates the expression (in this case Score) and executes the first case that satisfies the expression. For example... say Score = 29. The first case (<25) fails because 29 is not less than 25. The second case (<36) passes because 29 IS less than 36. So the command Grade = "D" is executed and the code jumps to the End Select.


Randy

 

[madrappin]

Can I use that statement as a subquery or do I set it up as a query by itself?

 

[randy700]

In design view of your form, select the text box that you plan to type the score in. Right click to bring up the properties window. Select the event tab. Select the After Update event. Click on the box to the right containing three dots. Select code builder. This will bring up the code window and you should see something like this....
Private Sub Something_AfterUpdate()

End Sub

Put the code between those two lines. Go back to the form, switch to form view, and enter a number in text box.


Randy

 

[madrappin]

Thanks! That worked perfectly thanks for your help.