Using VBA to Change Control Captions

[dftjsn]

I have a form on which I want to change some of the control captions on the fly with VBA prior to opening it with OpenForm. It seems that I'm only able to change the control captions after the form has been opened. In another circumstance it doesn't work at all when I open the form with OpenForm "Form Name",,,,,acDialog. Can I use VBA to change control captions before opening the form and why can't I seem to change control captions of a form opened with acDialog?

Thanks!

dftjsn

 

[seaport]

It is certainly doable.

1. Before opening the form, set the value of the form caption to a public variable pstrCaption.

2. In the form open event, set the form caption to be pstrCaption.

Seaport.