On Thu, 25 Feb 2010 03:25:09 GMT, "Benjamins via AccessMonster.com"
u39077@uwe wrote:

Perhaps you need to place a strategic "DoEvents" call so the screen
has time to update itself.

-Tom.
Microsoft Access MVP


Hi,

I using Access 2003

I have a module. The module will open a form when it was executed and will
close the form once finishes.

The from has a label to show the user the system is still processing by using
the form timer. The form works fine working on itself.

Once i use the module to run the code, the form loaded but does not show
anything and close once finished

Below is the example of Code

Module:
Public function StartModule()
Docmd.OpenFrom "ProcessBar"
'Code that is need for the module
...
...
...
Docmd.Close acFrom "ProcessBar"
End Function

How do i make the form work.