Question Hide/Unhide control based on field value

[josephbupe]

Hi,

I have placed an image control in a form but I want the image to be visible only when the value in the combo box is "Deceased".

I am trying behind the combo box afterupdate:

If Me.cboStatus.value="Deceased" Then
Me.imgDeceased.visible=True
 
Else
 
Me.imgDeceased.visible=False
 
End If

With this all records opened in that form have the control visible. How can I handle this properly?

Joseph

 

[MStef]

I suppose that your form is a CONTINUOUS,
and a field "imgDeceased" is UNBOUND.
Bound that field with the field in the Table.

 

[josephbupe]

I suppose that your form is a CONTINUOUS,
and a field "imgDeceased" is UNBOUND.
Bound that field with the field in the Table.

Hi,

The form is NOT continuous, and yes the imgDeceased is unbound. It's a png format ment to display across diagonally.

See attached short if that would be possible to do.

Thanks.

Joseph

 

[pbaldy]

Typically you would need the same code in the current event to handle the changing of records.