Question Change Combo Box when value entered on a Testbox

[Steve_T]

I all,

I have a Textbox called "Cost" with is set at currency format and a Combo box called "Status" which has two options "Open" and "Closed", (Default value of "Open").

What i am trying to do is when the cost is changed to anything greater then £0.00 the Combo box changes it's value to "Closed".
I have tried the following If statement but it is not working, i think it is down to the fact that its a currency value????????

If Me.Cost >= "£1.00" Then
Me.Status = "Closed"
Else
Me.Status = "Open"
End If

Any Help would be great.

 

[twoplustwo]

Try...

If Me.Cost >= "£1.00" Then
Me.Status.Visible = FALSE
End If

 

[Steve_T]

Thanks for help but unfortunatly all it does is make the Combo box invisable when any change is made whether its £0.00 or £1.00

I need the value to change to "Closed" as a querie will run upon exit of the form.

 

[twoplustwo]

Ah I see, misunderstood you I think

Not sure how having the currency in there affects it.

 

[Steve_T]

Thanks anyway mate, have a good weekend

Steve