Adding a check button to add a picture

[Hokis]

Hi,
I have a check box on my form & i need a code on click it shows me a picture on my report that is attache dto my form.??? can i do that??
Thanks
Hokis

 

[JoanneM]

Hello Hokis

You don't say if the graphic is stored in the table sourcing the form or another table.

I am presuming the picture is stored in another table which has a foriegn key to the primary key in the table sourcing your form

If that is the case a query containing both tables linked on the key will put the graphic into the forms data source - provided the query is the data source used.

Once it is in the data sourcing your form
put the picture field on to your form and name it
tnen
set the visible property to false


You can then on the on click property event of the check box
type something along the lines below

this should make it visible if hidden an invisible if shown
on clicking you check box

-picname being replaced with the name of the picture object name

  if  me.picname.visble = true 
  then 
      me.picname.visible = false
  elseif  me.picname.visble = false
  then 
      me.picname.visible = true  
  end if

Hope this is what you are trying to do

regards
jo

 

[Hokis]

Well I don't have the pic in any table I just have it on the form which I have the check box on it & a print button, which when i click it, a specific Report Prints,
So I want to when I click on the Form check box the pic. that i have on the form (ot maybe i have to put it on the Report insead), print it on the Report that I'm printing.
Does this make sence?

 

[Hokis]

any help pls!!!???