Results 1 to 3 of 3
  1. #1
    spidge32 is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2021
    Posts
    58

    How to open and sync form from multi line sub form

    Hi all, I have a multi line sub form which has one field where not all the data can be shown. I wish to open another form which shows all the field so it canbe seen or edited. I how do I open the new form on the correct record. it always opens to the first record. How do I sync this new form?



    Thank you in advance for your help

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    You apply filter criteria with the OpenForm command. Review:

    https://stackoverflow.com/questions/...w-in-ms-access

    Might also find this of interest https://support.microsoft.com/en-us/...8-a2c2e83dcedf
    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
    spidge32 is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2021
    Posts
    58
    Quote Originally Posted by June7 View Post
    You apply filter criteria with the OpenForm command. Review:

    https://stackoverflow.com/questions/...w-in-ms-access

    Might also find this of interest https://support.microsoft.com/en-us/...8-a2c2e83dcedf



    Thanks,

    This works well for me.

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

Similar Threads

  1. Replies: 2
    Last Post: 03-15-2022, 02:24 AM
  2. Replies: 4
    Last Post: 11-22-2021, 11:10 AM
  3. Replies: 4
    Last Post: 03-25-2019, 07:18 AM
  4. Open DB without Sync to SharePoint
    By Aidan74 in forum Access
    Replies: 0
    Last Post: 01-13-2017, 06:07 AM
  5. Replies: 0
    Last Post: 03-14-2012, 07:23 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