By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,498 Members | 835 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,498 IT Pros & Developers. It's quick & easy.

Calling a Form Function limited to 1 argument?

P: n/a
Lots of posts explained to me how to invoke a function inside a form
from another form.

Unfortunately, it appears that a function inside a form can have at
most 1 argument. I can create a form function that accepts multiple
arguments, but when I add a call to this function from elsewhere,
Access generates a Compile/Syntax error.

Is this true? Is the only way around it to join multiple arguments
into a string before the call and split them apart inside the
function?

Thanks.

Jeff
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 19 Jan 2004 16:16:48 -0800, jw*********@attbi.com (Jeff Wilson) wrote:
Lots of posts explained to me how to invoke a function inside a form
from another form.

Unfortunately, it appears that a function inside a form can have at
most 1 argument. I can create a form function that accepts multiple
arguments, but when I add a call to this function from elsewhere,
Access generates a Compile/Syntax error.

Is this true? Is the only way around it to join multiple arguments
into a string before the call and split them apart inside the
function?

Thanks.

Jeff


A public function in a form module can have as many arguments as you want.
What problems are you having trying to implement this?
Nov 12 '05 #2

P: n/a
On 19 Jan 2004 16:16:48 -0800 in comp.databases.ms-access,
jw*********@attbi.com (Jeff Wilson) wrote:
Lots of posts explained to me how to invoke a function inside a form
from another form.

Unfortunately, it appears that a function inside a form can have at
most 1 argument. I can create a form function that accepts multiple
arguments, but when I add a call to this function from elsewhere,
Access generates a Compile/Syntax error.

Is this true? Is the only way around it to join multiple arguments
into a string before the call and split them apart inside the
function?


Post the function call you are using and the first line of the
function (the one with the word "function" in it).
--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.