Results 1 to 4 of 4
  1. #1
    glasshouse is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    1

    Switchboard on top

    Dear Forum,



    I have a small knowledge of Access and have created a simple database. I'm trying to set up a switchboard that opens a couple of forms built on a simple queries. The forms use criteria lookups from the query to select the criteria and shows the data in query datasheets.

    The problem is the switchboard/form always remains on top of the queries when they run. The forms, not the switchboard, are set to close once they open the queries.

    I have set both "pop-up" and "modal" to no in the properties and tried to set the focus to no avail. Nothing I do, or have researched, stops the switchboard remaining on top.

    I'm looking for a very simple solution as I don't know how to use VBA.

    Thanks for any help.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Can you supply a copy of your database with fake data in it? if so create a fake copy, put in some garbage data, zip it up and upload it to this site, if the pop-up and modal are both set to no I'd have to look at it to figure it out.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Go to Form Design View then go to Properties - Other; is the Popup Property for the Form set to Yes? If so, change it to No, as it should be for this type of Form.

    Linq ;0)>

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Yeah he said he'd already checked the pop up property and it was set to no though.

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

Similar Threads

  1. Switchboard
    By mkc80 in forum Access
    Replies: 2
    Last Post: 05-17-2012, 06:44 PM
  2. Switchboard
    By rkalapura in forum Forms
    Replies: 4
    Last Post: 03-19-2012, 04:03 PM
  3. Help with second Switchboard
    By Kirsti in forum Forms
    Replies: 0
    Last Post: 02-21-2012, 07:43 PM
  4. Replies: 7
    Last Post: 09-13-2011, 01:38 PM
  5. Switchboard
    By mwabbe in forum Access
    Replies: 4
    Last Post: 08-26-2010, 07:17 AM

Tags for this Thread

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