Results 1 to 4 of 4
  1. #1
    HoldenC is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Sep 2016
    Posts
    2

    After splitting database, having problem displaying data from lookup table in a form

    Hello, I'm having a problem since splitting our database. Data does not display properly in a form. Here is what it looked like before we split the database:



    beforesplitting.pdf


    Here is what it looks like now:

    aftersplitting.pdf


    The DSDName Lookup is where we type the first few letters of the name, then lookup the rest of it in a table and fill the other fields with the linked data. I know that the correct data is still being saved to the DSDName because I can go to the table and check it and/or print reports but I cannot get it to display in the form. The data displays as you type it but as soon as you select the match in the lookup table, the other fields get filled but this field goes blank and stays that way.

    This never happened until we split the database. Does anybody have a suggestion on how to correct the display?

    Thanks!


    Here is the property sheet for the combo box lookup:
    combo property sheet.pdf

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Is that field bound to a field in the table? maybe unbind or bind it if needed. Also check to see if the table location or name has changed once you linked it in.

  3. #3
    HoldenC is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Sep 2016
    Posts
    2
    Thanks for the reply. After I initially posted I realized a workaround in that if I convert the linked table to a local table for each user then everything displays correctly again. Of course, this would seem to create a new problem in that users will not have access to the new lookup values created by other users.

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Could you post the FE & BE with maybe 1 record to illustrate the problem?

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

Similar Threads

  1. Replies: 1
    Last Post: 08-25-2015, 02:34 PM
  2. Problem Splitting a Database
    By euphonium01 in forum Access
    Replies: 4
    Last Post: 06-30-2015, 07:15 AM
  3. Displaying data from table on Calendar form
    By Voodeux2014 in forum Forms
    Replies: 1
    Last Post: 05-07-2015, 03:16 PM
  4. Replies: 2
    Last Post: 11-19-2012, 10:54 AM
  5. Form not displaying source table data
    By Sarge, USMC in forum Forms
    Replies: 6
    Last Post: 10-25-2010, 07:36 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