G
Guest
where are saved these functions ? o how do i save one
and how can i run it with a command button ?
and how can i run it with a command button ?
F
fredg
User Defined functions are functions you design yourself to return a
value.
They are stored in a Module.
On the main database folder, click on Modules
Write your function in the code window that opens:
Function DoSomething(FieldIn)
'Function code goes here
DoSomething = some value
End Function
Exit the module and save it under a name other than "DoSomething".
You can run it from a query, Control Source, or code event.
As a control source:
=DoSomething([FieldName])
From a command button event:
strResult = DoSomething ([FieldName])
From a query:
Exp
oSomething([FieldName])