Results 1 to 5 of 5
  1. #1
    aqueousdan is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2016
    Posts
    20

    Data missing in form view even though it is there in the table...

    This is a question mainly aimed at user Ssanfu as he helped me an awful lot with my database problems but if anyone else can help please do so!

    I have the same problem as I posted about previously. I have gotten slightly further with seeing what happens though...

    When I put in details into my main form (called MBRForm) and tick to save the record, it saves correctly into the associated table (called MBR). When I load the form up again and flick through my records, parts are missing (namely the Engineer and Machine data only)

    I have attached my database to this post. (To user Ssanfu, this is a completely unmodified version of the file that you worked on for me)

    Thanks for looking again guys



    Dan
    Attached Files Attached Files

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    think your data is not populated correctly

    according to the MBR table for the first record

    SiteID=5 - OK
    FactoryID= 16 - OK - part of site 5
    EngineerID = 14 -WRONG - according to the engineers table, engineer 14 belongs to factory 18

    I also think you need to refresh the combo rowsources in the form current event as you move between records e.g.

    cboEngineerID.Requery

  3. #3
    aqueousdan is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2016
    Posts
    20
    I deleted the data from the MBR table and did some new ones and dont seem to get any anomalies like that again.

    It seems to be fine when I select engineers from Factory 1 but any others and it doesnt work properly.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    are you requerying on the current event?

  5. #5
    aqueousdan is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2016
    Posts
    20
    Sorry yes that seems to have worked perfectly! Thankyou very much!

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

Similar Threads

  1. VBA in form view overriding imported table data
    By thoughtgrenade in forum Forms
    Replies: 3
    Last Post: 07-22-2014, 09:54 AM
  2. Replies: 2
    Last Post: 01-28-2014, 10:13 PM
  3. Replies: 2
    Last Post: 02-23-2012, 09:03 PM
  4. View data in table on Form as Diary?
    By beha in forum Forms
    Replies: 2
    Last Post: 10-26-2011, 11:36 AM
  5. Replies: 9
    Last Post: 02-19-2010, 12:07 PM

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