Custom row source for combo box in continuous form in Access

by

I also hate Access, but you must play with the cards you are dealt.
Continuous forms are a wonderful thing in Access, until you run into any sort of complexity as is commonly the case, like in this instance.

Here is what I would do when faced with this situation (and I have implemented similar workarounds before):

Place an UNBOUND combobox on the form. Then place a BOUND textBox for the field you want to edit.

Make sure the combobox is hidden behind (NOT invisible, just hidden) behind the textBox.

In the OnCurrent event fill the listBox with the necessary data. Go ahead and “Limit to list” it too.

In the OnEnter or OnClick event of the textBox give the combobox focus. This will bring the combobox to the forefront. When focus leaves the combobox it will hide itself once more.

In the AfterUpdate event of the combobox set the value of the textbox equal to the value of the combobox.

Depending on your situation there may be some other details to work out, but that should more or less accomplish your goal without adding too much complexity.

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. What are the rules governing usage of parenthesis in VBA function calls?
  5. Autonumber value of last inserted row – MS Access / VBA
  6. Microsoft Access condense multiple lines in a table
  7. How to get random record from MS Access database
  8. Code to loop through all records in MS Access
  9. Syntax error in insert into statement – what’s the error?
  10. create form to add records in multiple tables
  11. Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb
  12. How do I force VBA/Access to require variables to be defined?
  13. Why is my query not updateable?
  14. Microsoft Access DBEngine.OpenDatabase() breaks for Network-Paths – Error 3050
  15. Is it possible to create a recursive query in Access?
  16. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  17. What is the equivalent of Select Case in Access SQL?
  18. How do I access the selected rows in Access?
  19. Access 2007 – Left Join to a query returns #Error instead of Null
  20. Pivot Query in MS Access
  21. insert query with sequential primary key
  22. How do I execute multiple SQL Statements in Access’ Query Editor?
  23. how to show query results in a datasheet in the same form?
  24. Selecting 2 tables from 2 different databases (ACCESS)
  25. Setting up an MS-Access DB for multi-user access
  26. connected combo boxes in continuous form – the second combo doesn’t show its value if dependent on first combo how could I fix that
  27. MS Access prepared statements
  28. Linked table ms access 2010 change connection string
  29. Create sequential ID value based on the year that a record is added
  30. How to add a menu item to the default right click context menu

Leave a Comment