Results 1 to 13 of 13
  1. #1
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60

    open form on another form

    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.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Look at the options for OpenForm; one is acDialog.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60
    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

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    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.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60
    Quote Originally Posted by pbaldy View Post
    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

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    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.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    TOMMY.MYERS668's Avatar
    TOMMY.MYERS668 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Location
    West Virginia
    Posts
    77

    Re: open form on another form

    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

  8. #8
    TOMMY.MYERS668's Avatar
    TOMMY.MYERS668 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Location
    West Virginia
    Posts
    77

    Re: open form on another form

    There is also a docmd. Command to close the login form once your authentication is complete.

  9. #9
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60
    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

  10. #10
    TOMMY.MYERS668's Avatar
    TOMMY.MYERS668 is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Location
    West Virginia
    Posts
    77

    Re: open form on another form

    Yep gotta be code. Did you find the section in the form properties called on load?

  11. #11
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60
    Quote Originally Posted by TOMMY.MYERS668 View Post
    Yep gotta be code. Did you find the section in the form properties called on load?
    in (on load) event first show the login form (don't show the main form) and after login successfully show the main form

  12. #12
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Did you miss

    Quote Originally Posted by pbaldy View Post
    Or the timer event if the main form isn't fully showing using the others.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  13. #13
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60
    I find it
    just go in onload event and write this code
    Code:
    docmd.restore
    docmd.openform "login"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-11-2012, 11:52 AM
  2. Replies: 1
    Last Post: 05-03-2012, 02:25 PM
  3. Replies: 11
    Last Post: 01-26-2012, 01:22 PM
  4. Replies: 1
    Last Post: 12-04-2011, 09:11 PM
  5. Replies: 2
    Last Post: 02-26-2010, 08:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums