form to show vba progress

[AUGuy]

Reposting this here to maybe better suit the question to proper forum, since this involves more vba than form. Hope this isnt a faux pas!

I've got a daily process VBA code that runs several commands, queries, and macros every morning. I'd like to have a form that pops up when it runs to show the status of the process. This is important for me to show if it doesnt complete, that the user would be able to see the last process completed. It needs to dynamically change from Complete to Not Complete as each task is completed of course. The form layout would produce something similar to what i'll show below:

Daily Process:

Task 1: Complete
Task 2: Complete
Task 3: Not Complete!

The form could draw the Complete/Not complete from a table which is updated via VBA when process are executed.

My problem is this:
1. I'm not sure how to go about displaying the table data in the form without doing a list box.
2. I dont know how to update the form once a value in the complete/not complete table is updated. (i tried playing around with me.repaint but never could get it to work)

Thanks in advance for any help
G

 

[SpentGeezer]

Try this from the Spent Geezer's Association:

 

[AUGuy]

YES!! Exactly what i envisioned. Thanks so much! Now to replicate in my db!