Results 1 to 4 of 4
  1. #1
    Twitchie is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    20

    Split DB Not Displaying Combo Box Data


    Greetings. A colleague has a db in which she has split it for multiple user support. Before it is split, when you cycle through records in a form, the option that was selected when the record was saved displays in all combo boxes just fine. However, after the db is split, the combo boxes no longer display the selections. The values are in the table. Text, date, and memo fields display fine. It's just the combo boxes that are affected. Any ideas?

    She's using Access 2010. Thanks much!

  2. #2
    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
    Just to be sure, before people start trying to help, after splitting the database, was a copy of the Front End (with everything except the Tables) placed on each user's hard drive, with the Back End residing on a shared server?

    Linq ;0)>

  3. #3
    Twitchie is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    20
    Quote Originally Posted by Missinglinq View Post
    Just to be sure, before people start trying to help, after splitting the database, was a copy of the Front End (with everything except the Tables) placed on each user's hard drive, with the Back End residing on a shared server?

    Linq ;0)>
    Yes. In trying to help her track down the issue, I did a test using a copy of the FE as well as created a shortcut to the FE. Both resulted in the empty combo boxes. All other fields populate just fine. It's only the combo boxes that have the issue.

  4. #4
    Twitchie is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    20
    Upon closer inspection, she had all of her combo boxes set to Text on the table field lookup tab. Thanks!

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

Similar Threads

  1. Replies: 1
    Last Post: 07-07-2013, 12:47 PM
  2. Replies: 1
    Last Post: 11-22-2011, 02:36 PM
  3. Combo Box Displaying Text, But Storing ID
    By SeaTigr in forum Forms
    Replies: 4
    Last Post: 11-22-2011, 08:58 AM
  4. Replies: 2
    Last Post: 09-16-2010, 06:12 AM
  5. Displaying URL in a form combo box
    By jedwhines in forum Forms
    Replies: 0
    Last Post: 10-27-2009, 09:31 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