One Module for several slightly different forms

[EricRex]

Hey there,



I have several forms that are slightly different but use the same code base to populate them. The existing modules literally only have a Form_Open Sub with a subroutine call to the common code base.

Wondering how I can eliminate these redundant modules for these slightly different forms and just use one module for all of them?

Thanks,
Eric

[Welshgasman]

Would really help if you showed the code?

[davegri]

If the only code in the form's module is Form_Open, you can delete the modules and use this technique to call the common code:
(Use your procedure name, but it must be a function)

[Micron]

I have several forms that are slightly different

This can often be avoided by making one or two forms more flexible. Not enough info to say that is an option or not. Seeing the db would probably settle that.

[EricRex]

If the only code in the form's module is Form_Open, you can delete the modules and use this technique to call the common code:
(Use your procedure name, but it must be a function)

Awesome! This is exactly what I wanted.

THANKS!