Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2007
    Posts
    42

    Unanswered: 2007 Users can't see SubForm

    Help! I have an application where one of the sub-forms cannot be seen by any of my users who are on Access 2007 while the users running Access 2003 can run the form just fine. I am developing with 2003.

    * I have verfied that the 1:M relationship between the parent & child tables is setup correctly and working. The parent has 3 fields which are repeated on the child table as foreign keys.
    * I have verified that the parent/child links are setup correctly between the form and sub-form. Those same 3 fields are used as the link.
    * I have verified that both the form & sub-form are setup to allow adding, updating, and deleting records.
    * I have verified that the record source query for the sub-form is valid and working.
    * This same form has 4 other sub-forms that are working just fine. The 2007 users can view them without any problems.

    This is a simple sub-form - it has no VBA code behind it (although the form has a lot of VBA coding especially to populate fields at the top of the screen in the FormLoad().)

    Presently, the table is empty.

    Most of my users are running on VISTA with either Access 2003 or Access 2007, with the exception of a few. I am developing on XP using Access 2003.

    Any ideas would be greatly appreciated. Thanks!

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Have you tried opening up the design model in 2007? Perhaps running the form in 2007 might produce some hits as to what actually is wrong?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Apr 2007
    Posts
    42

    Problem Solved

    Thanks for the suggestion. Upgrading was my last resort since I don't have a copy of 2007 available without traveling to the office (I'm a telecommuter in another area of the country). I ended up finding the problem though - somehow the recordset ORDER BY had gotten a zero in it. Access 2003 must have just ignored it, but Access 2007 didn't know what to do with it and didn't open the sub-form.

    Thanks for your help.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, notice how the "new improved" 2007 is dumber? There's a lot of that in 2007 :s
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •