Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Don't care about nor need real data. See instructions again. No other way I will be able to help because can't see issue with posted code. Have you attempted debugging? it is what I would do if you provide db.
    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.

  2. #17
    jasonm is offline Novice
    Windows Vista Access 2003
    Join Date
    Oct 2012
    Posts
    22
    Your debugging how-to really helped. It pinpointed the problem to my append query for the 2nd subform - now that problem has been fixed. It has however led to another problem.

    If there are 2 addresses or more (addresses are kept in the 1st subform different records though), the programming recognizes the contacts (2nd subform) in the first address BUT puts them in the last address. Any other contacts linked to addresses other than the 1st address seem to be ignored.

  3. #18
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    I do not understand any of that because I don't know your db structure.
    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.

  4. #19
    jasonm is offline Novice
    Windows Vista Access 2003
    Join Date
    Oct 2012
    Posts
    22
    What do you need from me so you have a better understanding? Any help at all would be appreciated.

  5. #20
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    You can again try to describe what you want to happen and give more info about data structure, but really, doubt that will get us very far. Seeing db might be the only way for me get a grasp of the situation.
    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.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Multiple subforms to one main form
    By mick3911 in forum Forms
    Replies: 8
    Last Post: 02-25-2013, 09:40 PM
  2. Replies: 4
    Last Post: 02-13-2013, 10:46 AM
  3. Replies: 1
    Last Post: 08-02-2012, 02:11 PM
  4. Replies: 0
    Last Post: 12-16-2008, 07:49 AM
  5. Replies: 2
    Last Post: 04-11-2006, 08:40 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