How to call a procedure from a module in Access 2010..???

[kbsudhir]

Hi All,

I have create procedure called "Test" in Access 2010. I want to call this procedure in a button click & also when the form loads.

But the problem is Access 2010 is only allowing me to select from the existing list of macros which is available by default.

I have created a web database.


Please let me know to overcome this.

Regards
Sudhir

 

[pr2-eugin]

Sudhir, Have you considered using VBA instead of Macros?? To call procedure using Macros, you have to use the "RunCode"..

 

[nanscombe]

... note the procedure has to be a Function not a Sub to call it via the RunCode macro option.

 

[kbsudhir]

Hi,

Thanks pr2-eugin & nanscombe.

But, I am not getting Runcode option in the list of macros.


Please guide.

Regards
Sudhir

 

[JANR]

I have created a web database.

If you want to call and use code, you can't use WEB-forms, only in client-forms is code availible, sorry

JR