Message form during progress of activity.....

[Guest]

I have command button in other form and when it is clicked following code
gets executed.

DoCmd.OpenForm "FIN_Report_ Progress_Status", acNormal, "",
"[Progress_count]=2", acReadOnly, acNormal DoCmd.Close acForm,
"FIN_Report_ Progress_Status" DoCmd.OpenForm "FIN_Report_
Progress_Status", acNormal, "", "[Progress_count]=3", acReadOnly, acNormal

Fin_Report_Progress_Status Form has a filter.

In between these codes there are several other codes that are getting
executed. After executing some other codes following code does not get
executed.

DoCmd.OpenForm "FIN_Report_ Progress_Status", acNormal, "",
"[Progress_count]=3", acReadOnly, acNormal DoCmd.Close acForm,
"FIN_Report_ Progress_Status" DoCmd.OpenForm "FIN_Report_
Progress_Status", acNormal, "", "[Progress_count]=4", acReadOnly, acNormal

Please advice what needs to be done.

Regards.
Tejas Shah

 

[Guest]

you could use the progressbar developped by Albert D. kallal.
Unfortunately I did forgot the website.
However searching the forum for his name and/or wordmerge (this uses the
progressbar) will help you out.

good luck
Harry