Hi,

I was wondering what the best way to let a user know that there will be a potential delay (Something along the lines of, "Please be patient and Don't boot up your computer, as this form takes a pretty damn long time to open")

I tried the docmd.hourglass, but that only changed the icon after the form loaded...

this application.echo doesn't work either:


Application.Echo True, "Loading Page, Please wait..."
DoCmd.OpenForm stDocName, acDesign, , stlinkcriteria
DoCmd.OpenForm stDocName, , , stlinkcriteria
Application.Echo True

Any ideas?

This article will tell you how to create a "Please Wait" message. It is Access2000 but the code is the same for Access97.
http://support.microsoft.com/support/kb/articles/Q209/6/08.ASP?LN=EN-US&SD=gn&FR=0&qry=%26quot%3BPlease%20Wait%26quot%3B&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Thanks Jack: Worked like a charm.

(which really is an inept phrase if you come to think of it - when's the last time you've seen a charm work?)