pokdbz said:
How do modules work first of all if you have an example that would be
great.
The question that I had is I need to pull a SSN off of one form to
another how can this be accomplished with a module?
A tutorial in Visual Basic programming is beyond the scope of newsgroup
discussion. You could start with the help files, or search the
newsgroups for "VBA programming books", or search the web for tutorial
sites.
Suffice it now to say that a module is an object that contains code
elements, which may include procedures (Functions and Subs), variables,
defined constants, and user-defined types. A module may be a "standard
module", in which case there is only one copy of it, and its code is
always available, or it may be a "class module", in which case an
instance of the module must be explicitly created, there can be more
than one instance in memory at the same time, and calls to the module's
code from outside the module must be qualified by a reference to the
specific instance of the module in question.
In Access, modules are written in VBA (Visual Basic for Applications).
Access supports both standard modules and class modules; form and
report modules are special cases of class modules. In the Access
environment, modules can take advantage not only of the general-purpose
VBA programming language, but special functions and methods, objects,
and properties made available by the Access application itself for the
purpose of manipulating the application programmatically.
I can't answer your specific question about pulling a SSN from one form
to another without knowing more of the details. Code in one form's
module can certainly get information from another open form, such as the
value of the SSN field of the curent record.
