I am very new to access and VBA so please excuse the idiocracy of the question, but, I'm trying to output a string to a bound textbox in a form based on the value of a calculated textbox. So here's what I have so far, and it works in that if I say debug.print it prints to the immediate box but it won't output to the textbox in the form.
- Private Sub LowReg_Click()
-
-
Dim output As String
-
Dim ctlLowReg As Control
-
-
If [Low Registration Raw] <= 18 Then
-
output = "--"
-
ElseIf [Low Registration Raw] <= 26 Then
-
output = "-"
-
ElseIf [Low Registration Raw] <= 40 Then
-
output = "="
-
ElseIf [Low Registration Raw] <= 51 Then
-
output = "+"
-
ElseIf [Low Registration Raw] <= 75 Then
-
output = "++"
-
-
End If
-
-
End Sub
LowRegistration Raw is a calculated field, and I'd like the field LowReg, which also appears as a textbox, to show either "--", "-", "=", "+", or "++" depending on the value of Low Registration Raw.
Thanks!