I would like to add code to open the form to the on click event of an unbound OLE object. I know I can easily make a button to open the form and place it in the form , I just thought it would be nice to use this shape, copy and paste (round rectangle with some color) from ms-word 2007. I put the code in, but when I click the object it doesn't run, however, if I right click first then left click the code runs and open the form. Why is this and what do I need to do to make it run when clicked? No big deal, just thought it would be cool. anybody help me pls?
My file name is "tense db"
Form name is "sample" (to be open)
OLEunbond object name = A1,Z1 to A50,Z50
Fhe form "sample" should be open when i click the ole name "A1Z1 to A50,Z50".
thats all for your code. thank you