Sarah,
What is the code for the function mm()?
What is A?
Is rstMenu a recordset and [BUTTON EVENT] a field in that recordset?
Have you attempted to set a break point and step through your code?
Is the "{" just a typo in your email or is it in your code?
Could you share more of your code?
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 13 Aug 2015 15:43:07 -0700
Subject: [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")
What is the code for the function mm()?
What is A?
Is rstMenu a recordset and [BUTTON EVENT] a field in that recordset?
Have you attempted to set a break point and step through your code?
Is the "{" just a typo in your email or is it in your code?
Could you share more of your code?
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 13 Aug 2015 15:43:07 -0700
Subject: [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: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar