Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Unanswered: Order By disables "New (blank) record" button

    Greetings all,

    My company recently upgraded to Office 2007 from 2003. This issue was not apparent using Access 2003, so I'm thinking '07 is the culprit, but I can't figure out how to fix it.

    I have a continuous form that is sorted on a Combo Box field that stores our Client ID, but displays the Client Name (Row Source is a query). When I sort the form by this Client Name field, the "New (blank) record" button is disabled. There is a lookup in the Order By property. When there isn't a lookup in the Order By property, I can add all the new records I want.

    Any ideas?

    Thanks,
    Chillman

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    withoiut seeing the SQL no.. but I jsut wonder if its a bound control and doing something with it screws about with the record navigation control. it may be that the changing of the order causes problmes in the form run time code
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Was the database itself "up"graded from 2003 to the 2007 format? When you don't have your new button, can you change other data in the query or does the entire recordset go into "read only" mode?

    Other than that, I'll wait to see some SQL too.
    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

  4. #4
    Join Date
    Jun 2006
    Posts
    2
    I get the same results whether the database is in 2003 or 2007 format. The recordset is updateable in the query behind the form (can add new records too), but not in the form when I have the lookup in the Order By properties of the form. So I've concluded that the query is not the culprit.

    The 2003 format database works fine with this setup when using Access 2003, but not when using Access 2007

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    So what is this "lookup" you have in your form's Order By property?
    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
  •