Public and Private Procedures
Just as variables and constants have a scope, so do
procedures. We can declare a
procedure using the Public
or
Private
keyword, as in:
Public Function AddOne(i As Integer) As Integer
or:
Private Function AddOne(i As Integer) As Integer
The difference is simple: a Private
procedure can
only be called from within the module in which it is defined, whereas
a Public
procedure can be called from within any
module in the project.
Note that if the Public
or
Private
keyword is omitted from a procedure
declaration, then the procedure is considered to be
Public
.
Get Access Database Design and Programming, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.