Hi see attached.
I have a very simple form based on a very simple table.
If the [Price] field is > 100 then I want to display the wording "High"
See code below where PriceType is determined to be "high" or "low" .
How do I get the "PriceType" displayed on the actual form. See my attempt gives an error.
Private Sub Form_Current()
Dim PriceType As String
If Me.price > 100 Then PriceType = "High" Else PriceType = "Low"