how load form?

[Guest]

Thanks for any help.
I have a database with a form and table, and I have a Autoexec macro that
openForm's the form, and a button on the form that is a Private Sub
Command72_Click(). I would like to put a InputBox after loading the form, so
I tried Private Sub form_open(), and that works, but the form is not showing
when the inputBox is displayed. I would like the form to be showing when it
happens. I changed it to form_load, but the code in Private Sub form_load
does not get executed. I say this because I have a msgbox in form_load, and
it doesn't happen. I also do a F9 for that line (debug trigger), but it
doesn't go the VB editor. Perhaps I have to declare something somewhere?
So to sum up, I want to execute some code automatically right after a form
is loaded, but form_open happens before the form is showing, and form_load
doesn't seem to be executing.
Thanks again.

 

[Guest]

Putting the InputBox in your Forms Open event should display it after the
form is displayed - maybe this behavior is different when displaying a form
from the Autoexec macro? You could try putting the input box in the activate
or current event procs instead - maybe that will work.

Jim Burke