Docmd? Using functions in a module

[Pete]

I typed a function up in a module, so i can use that
function in all of my forms. (Reason: its a function that
allows access to add a list of times together and go past
the 24hr mark -http://support.microsoft.com/default.aspx?
scid=kb;EN-US;210604-)

If anyone knows away around that, would love to hear your
suggestions.

But anyways. So in the module, it will get me a
HrsWorkedTotal which i need it to put in [hrsworked] in
the form.

How can I do this? Thanks.

 

[John Vinson]

I typed a function up in a module, so i can use that
function in all of my forms. (Reason: its a function that
allows access to add a list of times together and go past
the 24hr mark -http://support.microsoft.com/default.aspx?
scid=kb;EN-US;210604-)

If anyone knows away around that, would love to hear your
suggestions.

But anyways. So in the module, it will get me a
HrsWorkedTotal which i need it to put in [hrsworked] in
the form.

How can I do this? Thanks.

Set the Control Source property of the textbox on the form to

=HrsWorkedTotal(<whatever parameters you need>)