• is a sequence of statements, enclosed with Function and End Function statements


• can take arguments which is passed by a calling function



• without arguments, must include an empty set of parentheses ()



• returns a value by assigning a value to its name

A function is a set of tasks so that a piece of code can take care for the functionality of a database. The main difference between a function procedure and a sub procedure is that a function can return a value.

A function is created like a sub procedure with a few more rules.

To implement a function, remember that it is supposed to return a value. In the body of the function, describe what it is supposed to do. to return the right value, assign the desired value to the name of the function. Here is an example:

If you want to use the return value of a function in an event or another function, assign the name of the function to the appropriate local variable. Make sure you include the argument(s) of the function between parentheses.