Adding a common set of functions to a group of forms

  • Thread starter Thread starter Corey B
  • Start date Start date
C

Corey B

Hello,

I'm working on a Access project that requires a large number of
forms (~40+). I want to add a common set of functions to each of
these forms, but I'm not sure of the best way to do this. I can't
subclass the form in VBA, and creating a NewForm class that implements
UserForm and MyGenericInterface seems like a lot of unnessary work
(assuming it would work). I only see two options, implement
MyGenericInterface to each form I use, or more simply add a module to
go with each form and implement the functions I need there. Any
suggestions or reference for this type of problem?

Thanks very much,
Corey
 
Have you thought of putting the common set of functions in
one module (not a class module) and declaring each of them
as Public. That way, they only exist in one place but can
be referenced throught the project.

Hope That Helps
Gerald Stanley MCSD
 
Back
Top