Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62

    Unanswered: Combo Box problems

    Hello,
    I'm having problems with the combobox on the final form.

    The combobox is showing cells, the drop down part comes up with values. But I cann't select the value from the drop down cell, is not selecting, nor I can type to the cell.
    This db was working fine for months, no problems. No code changes.

    To solve the mistey - I even restored the db from a month ago, relink all the tables, but combobox still giving me issues.

    Can you please point in the right direction to fix these problems.

    thank you very much

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Not without more information.... we'd have to start guessing!

    Sounds like a data problem to me... if the cbo has been working for ages and it all of a sudden stops working.
    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
    Location
    Big City
    Posts
    62
    At this time the tables and querys not working well. I got an error message "ODBC call failed". Which never happen before. So I had to manually relink all tables. But still, I can't select the value from the drop down cell in the combobox
    Have no idea what else to do ???
    Thanks a lot for your help.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Why not just re-create the combo box?

    I can offer little else since you've given no details on how the table structure is, what SQL is behind the combo box or what SQL is behind the form with the combo box.
    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

  5. #5
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62
    Thank you for your help, but I was able to fix the issue. I had to recreate all the ODBCs links along with removing and relinking all sql tables back to the database. And its working. .

Posting Permissions

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