Message Box

[Ham]

I have a very long-running VBA procedure in Access 2000. I would like to be able to display a status message as it is running. I don't want to use MsgBox because I don't want the user to have to hit 'OK' all the time. With DoCmd.OPenForm and DoCmd.Close I can display and close a form. However, I haven't figured out how to set the value of a text box control on the form. Does anyone have any ideas? Any suggestions gratefully accepted. Thanks. -- Ham Rutledge

 

[MissyEd]

Hi there

I might be reading your query wrong, but have you tried this ?

Forms("form-name-here&quot.Controls("text-box-name-here&quot.SetFocus
Forms("form-name-here&quot.Controls("text-box-name-here&quot.Text = "Test"

Let me know if this works, I tried it out on v.97 and it was OK, but I havent done any work in v.2000
Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com

 

[Ham]

Missy Ed: Thank you for the help. I wound up setting up a form in VBA and setting it equal to the opened form. What you have suggested is much simpler and cleaner and does work. Thank you very much. -- Ham Rutledge