Is it possible???

[ranen]

I am trying to use my modules and very confuse how to use it.
First I want to use it because I do have a redudndant info on every form I have and I want those Public Sub be in global.

Second confuse because most of the code I have read they use module for functions.

Can you please help me figure out how to do it or is it possible to use class modules?

thank you

 

[DB7]

Of course it's possible to use class Modules. Class Modules are Form Modules.
A Standard module, is for Global functions/procedures.
From VBE window, Click "Insert", from menu. Then click "Module".
You are now in a Global or Standard Module.
You can't Use "Me", in a standard Module. You must use full refrence.

Function TotalPrice(curCost As currency)As currency
TotalPrice = curCost + Forms!frmSales!txtCommision 'as opposed to Me!txtCommision
End Function