connected combo boxes in continuous form – the second combo doesn’t show its value if dependent on first combo how could I fix that

by

This technique is known as cascading combobox. A very common topic. Be aware that if combobox RowSource uses an alias (displays text when saving ID) the text will not be available for display in all records when the list is filtered. This is especially disconcerting for users of continuous/datasheet view form.

Could have code that only filters second combobox when it gets focus then restore the full list when loses focus. Users will still see data briefly disappear from other records and may find distracting at first but will learn to disregard.

However, a workaround to maintain display of text is to include the combobox RowSource lookup table in a query used as form RecordSource. Bind a textbox to the descriptive text field from lookup table. Set textbox as Locked Yes and TabStop No. In continuous view, can size and position textbox on top of combobox to obscure combobox text but still show drop arrow (a “hybrid” control). In datasheet view the textbox will not be superimposed but text will be displayed.

If controls are superimposed, users accustomed to clicking into combobox text frame and typing input will encounter aggravation as the textbox will likely be the control they click. Tabbing to the combobox or clicking drop arrow will cause combobox to get focus and display over the textbox.

More Related Contents:

  1. How do i add percentage an Access query?
  2. How does one decompile and recompile a database application?
  3. How do you use version control with Access development?
  4. Microsoft Access condense multiple lines in a table
  5. Code to loop through all records in MS Access
  6. Bang Notation and Dot Notation in VBA and MS-Access
  7. How do I make a stored procedure in MS Access?
  8. How can I get table names from an MS Access Database?
  9. Syntax error in insert into statement – what’s the error?
  10. Is there any way to create multiple insert statements in a ms-access query?
  11. Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb
  12. Why is my query not updateable?
  13. Microsoft Access DBEngine.OpenDatabase() breaks for Network-Paths – Error 3050
  14. Is it possible to create a recursive query in Access?
  15. How do I access the selected rows in Access?
  16. MS Access LIMIT X, Y
  17. Prevent enabling of shift bypass – Access 2010
  18. Access 2007 – Left Join to a query returns #Error instead of Null
  19. Access query producing results like ROW_NUMBER() in T-SQL
  20. Pivot Query in MS Access
  21. insert query with sequential primary key
  22. Save password for ODBC connection to MS SQL server from MS Access 2007
  23. How to write Case Sensitive Query for MS Access?
  24. Setting up an MS-Access DB for multi-user access
  25. MS Access prepared statements
  26. Linked table ms access 2010 change connection string
  27. Create sequential ID value based on the year that a record is added
  28. How to use cross join in access?
  29. Get Name of Current VBA Function
  30. How to extract the schema of an Access (.mdb) database?

Leave a Comment