Calling a function for the default valuie

[Goofy]

I have created a form and the text box on it needs to have the current week
number in. I have created a function which return this value. This is a
function which sits in the module1.

However, when I run the form I get the error name?

Any ideas on what could be causing this ?

 

[Douglas J. Steele]

What's the code for the function? (Copy and paste into your reply, as
opposed to retyping it)

What did you name the module? (It cannot be the same name as the function)

How are you trying to use the function?

 

[Goofy]

Thanks. I fixed it now by using a formevent and putting the code in there.
But for the purposes of this question.

the following call was placed in the default value property

=module1.getWeekNumber( now ())

 

[Douglas J. Steele]

You don't need the reference to the module name when referring to the
function.

=getWeekNumber(now())

should have been sufficient.

 

[Goofy]

OK I accept that, but stating so does not really answer my question.

Thanks for your help!

 

[Douglas J. Steele]

Did you try using the function without putting the module name? If so, did
you get the same error?

 

[Goofy]

Yes I did get the same error.

Did you try using the function without putting the module name? If so, did
you get the same error?