Running procedures in other modules

[GaryRW]

I'm trying to run a procedure in a module under a separate form, i.e. open a form, run a procedure but pass some variables to that procedure as well.

I can just use onload event and put the variables I want in a control on a form and refer to them that way - not very elegant. What's the syntax to run a procedure in another module and pass it variables???

thanks for any help in advance.

 

[WildHare]

First off, if you're passing variables to something, it is a FUNCTION.

Secondly, if the function is in a standard MODULE (e.g. not in a form or report) you can call if from anywhere.

Pass it the values, and set the return value in an appropriatly typed variable

FUBAR = GetStatus(MyProject) Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm