Results 1 to 3 of 3
  1. #1
    kfschaefer is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2006
    Seattle, WA

    Problem Between Access 2003 & Access 2007 Displaying Forms Correctly, Office 2007

    I am in the process of validating my Access 2003 database and the functionality working in the new Access 2007 environment w/o converting to 2007 - will have mixed environments for awhile.

    The forms within the AK3 version work perfectly, however not in Ak7. When I open the form with the multiple subforms in AK3 if functions correctly, but for some reason when the same form/subforms open in AK7 the subform (datasheet view) will only display 1 record when it should be multiple records. When I view this subform outside of the Main form/Subform it displays the data correctly. The Query returns the correct records etc.

    Does anyone know why this is happening?



  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Never encountered issue like this when running mdb projects with 2007.

    Can you attach file to post or at least an extract of the relevant objects, or upload to fileshare site such as and post link to file. Remove confidential data, run Compact & Repair first.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Sometimes when the inexplicable is found - rather than find the solution, it is more quick & efficient to replace. You might try inserting a new subform into the main form to see if it works ok.

    Hope it helps.

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

Similar Threads

  1. Replies: 0
    Last Post: 06-03-2011, 09:03 AM
  2. Problem Saving Access 2007 to 2003 database
    By spkoest in forum Access
    Replies: 4
    Last Post: 05-03-2011, 04:44 PM
  3. Replies: 6
    Last Post: 12-01-2009, 11:59 AM
  4. Office versions with Access 2007
    By Coolpapabell in forum Access
    Replies: 0
    Last Post: 09-29-2009, 09:37 AM
  5. Access 97 compatable with Office 2007??
    By mkattengell in forum Access
    Replies: 1
    Last Post: 09-08-2009, 04:24 AM

Tags for this Thread

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