Results 1 to 4 of 4
  1. #1
    dwwally is offline Novice
    Windows 10 Access 2007
    Join Date
    Jun 2016
    Posts
    16

    Table is locked when selected from a list in a form

    When I select a table from a list object in a form, the table opens behind the form, but I cannot use the cursors or move or close the table. Only when I close the form, the table is now on top and I can use all the functions of the table. How can I unlock the table object while the form is still open?

  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
    I suspect the popup/modal properties are the cause, or it was opened using acDialog.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    dwwally is offline Novice
    Windows 10 Access 2007
    Join Date
    Jun 2016
    Posts
    16
    Thanks, setting the PopUp to off and the Modal to off in the form object solved the problem.

  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
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 13
    Last Post: 11-27-2014, 10:18 AM
  2. Replies: 11
    Last Post: 09-22-2013, 08:05 PM
  3. Replies: 3
    Last Post: 01-24-2013, 02:38 PM
  4. Replies: 14
    Last Post: 12-06-2012, 11:25 AM
  5. Replies: 1
    Last Post: 09-12-2011, 10:15 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