S
Shreenivas Potnis
It seems 'UnLoad me' does not work. is it possible to
close a after it looses focus. How?
close a after it looses focus. How?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell
Your question is a bit vague, but if I'm reading between the lines
correctly, your database has a startup form that is displayed and the user
does something on that form to move on to other actions.
If you have any controls on that startup form, then it doesn't actually have
a focus; the controls on the form can have the focus. A form gets focus only
if there are no controls on it that can receive the focus.
Second, Unload is a command for Userforms in VBA, but not ACCESS forms. In
ACCESS, you close a form this way:
DoCmd.Close acForm, "FormName"
Third, the easiest way to close a form is to use the code that runs when the
user clicks a button to go somewhere else. Insert the above line of code as
the last step in the code that is running in your startup form when the user
does something and you want the startup form to close.
correctly, your database has a startup form that is displayed and the user
does something on that form to move on to other actions.
If you have any controls on that startup form, then it doesn't actually have
a focus; the controls on the form can have the focus. A form gets focus only
if there are no controls on it that can receive the focus.
Second, Unload is a command for Userforms in VBA, but not ACCESS forms. In
ACCESS, you close a form this way:
DoCmd.Close acForm, "FormName"
Third, the easiest way to close a form is to use the code that runs when the
user clicks a button to go somewhere else. Insert the above line of code as
the last step in the code that is running in your startup form when the user
does something and you want the startup form to close.