how to open form on another form?
when second form opens on the first form, the first form puts behind of second form and is unavailable until second form closes
how to open form on another form?
when second form opens on the first form, the first form puts behind of second form and is unavailable until second form closes
Last edited by msasan1367; 02-20-2013 at 09:57 AM.
Look at the options for OpenForm; one is acDialog.
thanks but how to open second form when the first form open
I have login and main form
when I open main form, login form open on it automatically
I would just open the login form first, and the main from there. You could open the login form from the open or load event of the main.
but in this way, first it opens login form and when you login show the main form. but I want to show both (login form on the main form) and when login successfully it closes and main form come front
So open the form from the load or open events of the main form. Or the timer event if the main form isn't fully showing using the others.
As pbaldy said the event list for the form under open or load then I believe u want the code which should be:
Docmd.openform(form name here, acnormal)
Not sure which view u want but I think it would be acnormal
There is also a docmd. Command to close the login form once your authentication is complete.
like belown image:
there is main form and login form on it. when you can successfully login, the main form become available if you cant login, the main form is unavailable
Yep gotta be code. Did you find the section in the form properties called on load?
I find it
just go in onload event and write this code
Code:docmd.restore docmd.openform "login"