call VBA function from macro

's Computer Specifications

I would like to call Myfunction in form_main from my macro1

I use macro edit to put

RunCode

call from_main!Myfunction()

but I got

" MS access can not find call expression...."

Are there any way to call myfunction in VBA code from macro?

Any information is great appreciated,

's Computer Specifications

Souris,

Just put...
MyFunction()

It will have to be a public function.

--
Steve Schapel, Microsoft Access MVP

Souris wrote:
> I would like to call Myfunction in form_main from my macro1
>
> I use macro edit to put
>
> RunCode
>
> call from_main!Myfunction()
>
> but I got
>
> " MS access can not find call expression...."
>
> Are there any way to call myfunction in VBA code from macro?
>
> Any information is great appreciated,
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Function to call macro	ranswert	Microsoft Excel Programming	1	15th Jan 2008 10:02 PM
just need to create a function and call it with a macro	=?Utf-8?B?QW1hbmRhIEJ5cm5l?=	Microsoft Access Macros	1	15th Aug 2006 04:00 PM
Can a VBA Function be used to execute (call) a Macro?	=?Utf-8?B?UktHcmlmZmlu?=	Microsoft Excel Misc	2	23rd Nov 2004 04:01 PM
function or call macro	marko	Microsoft Excel Programming	4	8th Dec 2003 03:31 PM
Call Excel Macro/Function from PPT	daMike	Microsoft Powerpoint	1	13th Aug 2003 12:41 PM