Results 1 to 5 of 5
  1. #1
    gykiang is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2013
    Posts
    47

    records in different forms cannot be saved & updated

    I have 2 Linked forms :

    frmINVOICE
    frmINSURANCE

    Several of the fields in frmINVOICE are supposed to be repeated in frmINSURANCE, example Field name such as [Invoice No], [Invoice Date], [Description] etc. are identical in both forms.

    My problem : After update of the fields frmINVOICE, the linked record will not update in frmINSURANCE.

    I have manipulated by adding the below controls/commands to the field event and/or current form of both forms but nothing works :
    - DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
    - Refresh macro
    - Requery
    - Me.Dirty = False

    Nonetheless, I noticed following outcomes :
    1) if I tap between the forms twice, the field record from frmINVOICE will be updated automatically in frmINSURANCE
    2) when I close and open frmINSURANCE, no change occurs
    3) after I manually save frmINVOICE, then the field record from frmINVOICE will be updated in frmINSURANCE

    what should I do now ?

    Regards
    Kiang

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,076
    Why are you duplicating data? Are you saving this data into both tables?

    I would think the invoice record would save the insurance ID as foreign key, not invoice data in insurance record.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    gykiang is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2013
    Posts
    47
    No. The related fields are from Invoice Table and joined to the primary key of Insurance Table. There is no duplication of data.

    It now works only if I closed frmInvoice and open frmInsurance fresh.

    If frmInvoice is not closed, frmInsurance will not update. Similarly, if frmInsurance is left opened, even frmInvoice is closed, it will also not update. Refresh or requery of frmInsurance will not work too.

    I think it has to do with the dirty property of form.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    50,076
    Sorry, I don't understand data structure and relationships.

    If this is a form/subform arrangement, records should synchronize with the Master/Child Links properties.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    gykiang is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2013
    Posts
    47
    There are too many tables knitted together in the forms. I think I can live with the bug if it is just closing the form to get the fields updating in another form.
    Thanks for your advice and great help.

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

Similar Threads

  1. Forms arent displaying updated data
    By alexandervj in forum Access
    Replies: 3
    Last Post: 06-12-2014, 03:53 PM
  2. Replies: 8
    Last Post: 04-23-2014, 02:12 PM
  3. Replies: 5
    Last Post: 09-26-2013, 08:35 AM
  4. Forms Freezes After Record Is Updated
    By toonz in forum Forms
    Replies: 1
    Last Post: 10-04-2011, 01:09 PM
  5. Losing Records Saved From Form
    By ProgZ in forum Forms
    Replies: 2
    Last Post: 04-17-2011, 11:32 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 - Senior Forums