This may be the easiest problem ever, just can't seem to get it.
I have a Form called Orders.
In that form I have a couple text boxes, SubTotal and Shipping.
I want to change the value of the Shipping box depending on what the value of the SubTotal box is.
The way I'm trying to do it is in the OnChange event of the SubTotal box I have the following VB code:
It seems like a pretty common and simple thing to do but it just doesn't seem to work. I've tried several different version of the above but none of them worked.
I'm new to Access and only have a rudimentary programming knowledge, so that's why I'm having trouble here.
Thanks,
Tom
I have a Form called Orders.
In that form I have a couple text boxes, SubTotal and Shipping.
I want to change the value of the Shipping box depending on what the value of the SubTotal box is.
The way I'm trying to do it is in the OnChange event of the SubTotal box I have the following VB code:
Code:
Private Sub SubTotal_Change()
If Me!SubTotal < 100 Then
Me!Shipping = 5
Else
Me!Shipping = 6.5
End If
End Sub
It seems like a pretty common and simple thing to do but it just doesn't seem to work. I've tried several different version of the above but none of them worked.
I'm new to Access and only have a rudimentary programming knowledge, so that's why I'm having trouble here.
Thanks,
Tom