Results 1 to 7 of 7
  1. #1
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544

    Question Form always goes stays in focus

    I have a main form that opens up when the database is open. I need the form to stay open as it acts as the main menu for users. When I run the main process my function asks if the user wants to advance to another form. If the user clicks "Yes" in the message box to go to the other process my main form "forces" on top. I've tried setting form to visible and everything. When I step through the code it comes back into the foreground when it exits the "On Open" event. Any ideas?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,623
    Is the main menu form Modal or Popup property set to Yes?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Quote Originally Posted by June7 View Post
    Is the main menu form Modal or Popup property set to Yes?
    Both are set to "No".

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,623
    The form opens by Autoexec macro or CurrentProject default form setting? Code somewhere seems to be setting it to modal. Are you able to click on other forms?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Quote Originally Posted by June7 View Post
    The form opens by Autoexec macro or CurrentProject default form setting? Code somewhere seems to be setting it to modal. Are you able to click on other forms?
    Autoexec macro. Yes, I'm able to click on buttons, type in boxes, etc.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,623
    I also have a main menu form that remains open but all subsequent forms open on top and the main menu is not viewed until other forms are closed. I don't use macros, only VBA. Something is controlling this behavior. My first suspects are the macro or the form's Open event. Do you want to provide project for analysis?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Macro was the culprit. I changed the database to simply open the form as "default" and works fine. Thanks for the help!!

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

Similar Threads

  1. HELP! Set Focus to Continuous Sub Form Field
    By asmith78 in forum Programming
    Replies: 1
    Last Post: 09-09-2011, 02:27 PM
  2. Changing focus on a form
    By Shag84 in forum Forms
    Replies: 3
    Last Post: 07-15-2011, 01:51 PM
  3. Grow text box on form with focus
    By Karen H in forum Forms
    Replies: 5
    Last Post: 02-25-2011, 12:03 PM
  4. Replies: 1
    Last Post: 12-10-2009, 09:58 PM
  5. Setting Focus on a Form
    By MFeightner in forum Forms
    Replies: 1
    Last Post: 07-30-2009, 07:49 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