Image Click event

[zeidhaddad]

Hello People, I'm trying to figure out a code which perform this : clicking on a image to open a certain form.
I tried using this DoCmd.OpenForm "NameOfForm", , , "Image1=" & Image
where Image 1 is the name of the image that i want to click on to open the form. any ideas ?

 

[James006]

Hello,

Just right click and select Assign a macro ...

Hope this will help

 

[Joe4]

Just right click and select Assign a macro ...

That sounds like an Excel solution, not an Access one (this is posted in the Access forum).
Just to make sure, I tried it in Access, and don't see that option.

I think what you need to do is to select the image, right-click, select Properties, go to the Event tab, and kick off the Code Builder on the "On Click" event.

 

[James006]

Sorry for the confusion ...

Thought it was an Excel related question ...

 

[Joe4]

Thought it was an Excel related question ...

I am guessing that you were working from the "Zero Rreply Posts" list and didn't notice the forum listed in the right-most column.
It happens from time-to-time!

 

[James006]

I am guessing that you were working from the "Zero Rreply Posts" list and didn't notice the forum listed in the right-most column.
It happens from time-to-time!

Spot on ... !!!

 

[Micron]

It looks to me as if you're trying to pass an image name as the parameter for the Where condition. That will never work because it expects a sql statement that is a valid Where clause (without the word Where). I don't see where the image name that you're clicking on has anything to do with the form you want to open? Why not just DoCmd.OpenForm "NameOfForm" ?