Control the Form Using Module

We have created a form with a simple way in which the form has not been added or installed any feature that will help us work quickly - such as print or view current form. On the other hand, we have created a module contains functions that at any time we can call in such an easy way in the objects we have created. Basically, MS Access has feature to run the function in the module we have created but unfortunately, that function can only be applied in a predetermined form, namely through the class module. In contrast with the standard module, which is created as a separate object in the Access Navigation Pane.

Create Functions using Module

In MS Access, modules contain declarations, statements, and procedures or functions that are programmed in a structured and systematic manner as a single unified entity. There are two types of MS Access module, class module and standard module. Class module is on a form or report, and usually contains a specially programmed procedures for its form or report. Standard module contains general procedures that are not associated with or can be used on other objects - such as query, form, and report. Standard modules are listed under Modules in the Navigation Pane, while a class module not.