image controlled by a tables field

[hdesbiens]

Hi

i have a form invoice and a table invoice too, my form is linked to my table. I have a field that is named teminated and this field is telling me if the invoice is terminated or not.

What i want to do is to put something on my forms that tells me that this invoice is teminated, i have tried an image but cannot link my image to the table field.

So is there a way to do what i want to do?

Thanks a lot

 

[jadams0173]

Put the image on your form and set it's visibility to off. When you read the terminated field then if it is true( invoice is terminated) then set the image property to true/on otherwise leave it off.

 

[hdesbiens]

Ok perfect but i just dont know when to launch the event that will put my image visible or not!

Do you know which event could i use in the form to do that?

thanks a lot

 

[PHV]

Try the Current event of the form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MajP]

assuming it is a boolean field.

Private Sub Form_Current()
  imgOne.visible = Me.terminated
end sub

If it is not a boolean field

Private Sub Form_Current()
 if me.terminated = "Terminated" then  
    imgOne.visible = True
 else
    imgOne.visible = False
 end if
end sub

 

[hdesbiens]

Thanks a lot it works

i just didnt know this event!

Thanks