Problem with calling a visual basic function from a form field

[CSCS]

Dear All.

I have a visual basic function, placed in a module.
I need to call it from a form field, and pass a value to it and the function has to return a value.

I tried it but it doesn't work
the value I get on the field is " #Name? "

any help will be very appreciated.

Thanks!
CS.

 

[Bat17]

How are you calling the function and where is the fuction written?

the call to a function shoudl be in the controlls record source with the format
=AddVal(10)

Peter

 

[CSCS]

What do you mean by "value in the Name property on the Other tab is not the name of a field in the RecordSource"

 

[jrb_ph]

Can you paste the code what's this function is processing? What I understands is:

In the field record source;

=YourFunction(RecevingVariable) --- this maybe the name of the field itself...

Rody

 

[MarkK]

Make sure that the name of the control in which you are adding this function call does not have the same name as a field in the record source of your form.

The "Other" tab is the tab in the property sheet where you can rename a control. Format, Data, Event, Other, All.

 

[CSCS]

The names are not the same,

below is the link of the code I used:
http://support.microsoft.com/?kbid=210586

 

[Bat17]

can you post what you have on the form?

Peter

 

[godofhell]

You should be able to call it by simply typing:

ConvertCurrencyToEnglish(Your Number), make sure you pass a valid number so you might want to convert the value to number before passing it on to the fucntion. ie:

Dim myValue as Long
myValue = CLng(myTxtbox.value)

ConvertCurrencyToEnglish(myValue)