[MS_AccessPros] calling function in vba

 

i have a function 'mm'. I am trying to call this function with a variable from a table, it does not work, The exact same function works if I type the variable name directly into the statement. 

the following does not work, does not do anything. I tried with and without "()". does not make a difference

A = (rstmenu![BUTTON EVENT])

A = rstmenu![BUTTON EVENT]

The following works:

A = mm("Definition Menu")

 rstmenu!{button event] =mm("Definition Menu")

What am I doing wrong?

Sarah

__._,_.___

---

Posted by: sarahk@schemesoftware.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___