LeeHutchins
New member
- Local time
- Today, 20:38
- Joined
- Nov 3, 2020
- Messages
- 13
Hi,
I want my margin to calculate with every change of PAPrice usually would use me.FIELDNAME.text but this is a numeric value and doesn't seem to work that way.
this is what I have so far, but might be wayyyyyyy off.
with thanks,
Lee
I want my margin to calculate with every change of PAPrice usually would use me.FIELDNAME.text but this is a numeric value and doesn't seem to work that way.
this is what I have so far, but might be wayyyyyyy off.
Code:
Private Sub PAPrice_Change()
If Len(Me.PAPrice) > 0 Then
Me.Margin = (Me.PAPrice - Me.StandardCost) / Me.StandardCost
Me.Margin.Enabled = False
End If
End Sub
with thanks,
Lee