Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009

    Unhappy Unanswered: Clicking dropdown box triggers ODBC error

    Hello all,

    I am using an access 2003 frontend with a sql server backend.

    I have a subform that is set to have a Continuous Forms view. Each detail record has a dropdown box and a text box where the user can select the appropriate item(dropdown) and enter in the corresponding weight (text box).

    The trouble is with the dropdown box. The control source is the Item field on TableA. The row source for the drop down is the item description with the item id appended to it(column 1) and the item id(2nd column). The 2nd column is bound to the item field on TableA.

    When I pull up the form and click on the dropdown arrow, I get an ODBC Error:
    "ODBC -call faied.
    ...Cannot insert the value NULL into column "Item" ...column does not allow nulls. Insert fails. (#515)..."

    Is the db already trying to save back the record before I input in any data?
    If so, how can I prevent this?

    Thanks in advance for the help.


  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Sounds like you have your combo box bound to the wrong field (Item) or it's bound column is not set correctly. When you select an item from a combo box, only the key is sent to the underlying field, not NULLS.
    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