Access Database Design and Programming, Second Edition

Calling Subroutines

A subroutine declaration has the form:

[Public or Private] Sub SubroutineName(Param1 As DataType1, _
         Param2 As DataType2,...)

This is similar to the function declaration, with the notable absence of the As ReturnType portion. (Note also the word Sub in place of Function.)

Since subroutines do not return a value, they cannot be used within an expression. To call a subroutine named SubroutineA, we can write either:

Call SubroutineA(parameters, . . .)

or simply:

SubroutineA parameters, . . .

Note that any parameters must be enclosed in parentheses when using the Call keyword, but not otherwise.