HIDING AN IMAGE BASED ON COMBO BOX VALUE

[scott_baird]

I'm sure there are easier ways, but... I have a combo box that has 5
possibilities (one of which is "sold"). When the combobox.value=Sold,
I want an image to appear, otherwise to not be visible. So, I thought
I do an If Then Else statement, but it doesn't seem to be working...
I'm not entirely too proficient at access programming (enough to be
dangerous), but I did:

******************
If combobox.value = Sold then
image11.visible = true
else
image11.visible = false
End if
******************

I've placed this OnLoad, OnCurrent, OnChange, AfterUpdate, etc.. But
it just won't work. It shows up on a new form just fine, but when I
change status it disappears and will not come back when status is
changed to sold in the combo box. What am I doing wrong?

Scott

[David B]

<sc*********@japan.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

I'm sure there are easier ways, but... I have a combo box that has 5
possibilities (one of which is "sold"). When the combobox.value=Sold,
I want an image to appear, otherwise to not be visible. So, I thought
I do an If Then Else statement, but it doesn't seem to be working...
I'm not entirely too proficient at access programming (enough to be
dangerous), but I did:

******************
If combobox.value = Sold then
image11.visible = true
else
image11.visible = false
End if
******************

I've placed this OnLoad, OnCurrent, OnChange, AfterUpdate, etc.. But
it just won't work. It shows up on a new form just fine, but when I
change status it disappears and will not come back when status is
changed to sold in the combo box. What am I doing wrong?

Scott

How many columns are in your combo.
The statement is looking at column 0 ie the first one
That is often a number in which case your sold should be replaced with the
relevant number for sold

HTH
David B