2011-05-04, 01:50 #1
- Join Date
- Dec 2009
- Bogangar NSW Australia
- Thanked 2 Times in 2 Posts
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?
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!
+ 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!
2011-05-04, 15:33 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 12 Times in 12 Posts