The Return Command

[stoneferry]

Apologies for the poor question, I'm lacking in reference material at the moment.

I'm stuck on the VBA Access Return command. I'd like to return data from a module, to the source, however I don't know the syntax and I'm getting "Compile Error: Expected: End of statement"


My code so far, (although it's in draft form if it seems pointless at present). I'd like to pass 'result0101' back.


Function Con_0101(arg1 As String) As String

Public result0101 As String

result0101 = "this is a test for 0101"

Return result0101

End Function




And second question, where can I get a decent reference guide for simple command look-ups like this. The Microsoft help file doesn't seem to help.

Cheers
Stoneferry

 

[Remou]

Use the name of the function:

Function Con_0101(arg1 As String) As String

Public result0101 As String

result0101 = "this is a test for 0101"

Con_0101=result0101

End Function