Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Bogangar NSW Australia
    Posts
    105
    Thanks
    25
    Thanked 2 Times in 2 Posts

    Question Access Select Query Form Combobox Not Updating

    I have a Form which is bound on a Select Query. The Select Query includes links to each of the Tables bound to the Comboboxes. The Form has a number of ComboBoxes for selecting various options that are then to be written back to the Main Table. The Comboboxes each display the data from the Select Query, but when I try to change an option in any of the Comboboxes the dropdown list appears but on clicking an item in the list nothing happens - the list stays open and all I get is a "boing" sound.

    How can I make the Combobox selection work and save to the updated selection ID to the Main Table?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,325
    Thanks
    1
    Thanked 12 Times in 12 Posts
    Quote Originally Posted by BygAuldByrd View Post
    I have a Form which is bound on a Select Query. The Select Query includes links to each of the Tables bound to the Comboboxes. The Form has a number of ComboBoxes for selecting various options that are then to be written back to the Main Table. The Comboboxes each display the data from the Select Query, but when I try to change an option in any of the Comboboxes the dropdown list appears but on clicking an item in the list nothing happens - the list stays open and all I get is a "boing" sound.

    How can I make the Combobox selection work and save to the updated selection ID to the Main Table?
    I don't understand why you have links to all the tables in the comboboxes. You don't need them. This may have made the select query non-updatable, which is why the "boing" sound.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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
  •