Is there a simple way of populating dropdown in this Access Database schema?

by

It is a very bad idea indeed to name anything Name.

It seems to me that you need cascading comboboxes. You will need a little VBA.

Two combo boxes called, say, cboLocation and cboNodes, on a forrm called, say, frmForm

cboLocation 

RowSource: SELECT ID, [Name]
FROM Locations
ORDER BY [Name]

ColumnCount: 2

ColumnWidths: 0;2.00cm  ''The second column can be any suitable width

LimitToList: Yes

Events:

Private Sub cboLocation_AfterUpdate()
    Me.cboNode.Requery
End Sub

CboNode

RowSource: SELECT ID, NodeName
FROM Nodes
WHERE IP=[Forms]![frmForm]![cboLocation]
ORDER BY NodeName

ColumnCount: 2

ColumnWidths: 0;2.00 ''Ditto

LimitToList: Yes

Events:

Private Sub cboNode_GotFocus()
    If Trim(Me.cboLocation & "") = vbNullString Then
        MsgBox "Please select location"
        Me.cboLOcation.SetFocus
    End If
End Sub

You will also need a form event:

Private Sub Form_Current()
    Me.cboNode.Requery
End Sub

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. Autonumber value of last inserted row – MS Access / VBA
  5. Microsoft Access condense multiple lines in a table
  6. How to get random record from MS Access database
  7. Code to loop through all records in MS Access
  8. create form to add records in multiple tables
  9. Operation must use an updatable query. (Error 3073) Microsoft Access
  10. How do I force VBA/Access to require variables to be defined?
  11. Why is my query not updateable?
  12. Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present
  13. Is it possible to create a recursive query in Access?
  14. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  15. What is the equivalent of Select Case in Access SQL?
  16. How do I access the selected rows in Access?
  17. insert query with sequential primary key
  18. How do I execute multiple SQL Statements in Access’ Query Editor?
  19. How to select top 10 in Access query?
  20. how to show query results in a datasheet in the same form?
  21. Selecting 2 tables from 2 different databases (ACCESS)
  22. connected combo boxes in continuous form – the second combo doesn’t show its value if dependent on first combo how could I fix that
  23. MS Access prepared statements
  24. Linked table ms access 2010 change connection string
  25. UrlDownloadToFile in Access 2010 – Sub or Function not Defined
  26. Custom row source for combo box in continuous form in Access
  27. VBA – Run Time Error 3271 using DAO object
  28. Working with multiple programmers on MS Access
  29. Trouble with InputBoxes
  30. Get Name of Current VBA Function

Leave a Comment