I have a lot of code that takes a long time to run so I was curious if it was possible to have my code write to an open text box on a form from time to time to tell me what 'step' it's on. This way I know it's actually doing something and not freezing up. So with some help in another forum:
http://www.utteraccess.com/forums/sh...Post1723904&Zp=


I have the following code
Code:
Option Compare Database
Option Explicit

Public Function letstrythis()
    DoCmd.OpenForm "frmStatus", acNormal, , , acFormEdit, acWindowNormal
    Application.Forms("frmStatus").txtStatus = "Some update text line 1"
    Application.Forms("frmStatus").txtStatus = "Some update text line 2"
End Function
Which works fine but instead of writing a new line every instance of "Application.Forms("frmStatus").txtStatus" it writes over the old line. Is there a way to make this write a new line every time?