HELP!!! WITH FUNCTIONS!!

[Milan]

I HAVE A PUBLIC FUNCTION IN THE MODULES TAB. HOW DO I CALL (RUN) THE FUNCTION FROM A PRIVATE SUB PROCEDURE WITHIN A FORM? . HOW DO I GET A VALUE RETURNED BACK TO THE PRIVATE SUB FROM THE FUNCTION .

WOULD BE GRATEFUL FOR YOUR HELP

 

[David R]

Your question is a little broad. But, in general you can call a function defined in a public module just as you would any other Access function. For example
Dim User As String
User = UserName()
'UserName() being a public defined function
MsgBox "Good morning, " & User

You can also set a recordsource =UserName(), call a public function in a query, etc. Are you having a specific problem?
Keep in mind that you refer to the function by its function name, NOT the module name (which is, as far as I know, irrelevant).

HTH,
David R