Forum Discussion

Gilmour10's avatar
Gilmour10
Copper Contributor
Jul 05, 2024
Solved

Error in cascading Combo Boxes

Hi Access community,   In a form, I'd like to filter choices in combo box cobStatus based on the value I select in combo box cobCountry. The code I copied from an online post is:   Private Sub co...
access
  • Gilmour10's avatar
    Gilmour10
    Jul 17, 2024

    Hi XPS35, thank you for your help, I think I'm on the right path! 

     

    cobStatus now presents only the choices in the 'Status' field of the data source that are available for the selected country! However, this happens when, after selecting the country I go and try to select the Status:

     

     

    The system asks me to re-enter the country manually.

    1. How do I eliminate that error? and

    2. How can I filter the two other combo boxes based on choices made in the first two? What would the After Update event look like for Concept and Project Type? 

     

    Thank you so much for your help!

XPS35's avatar
XPS35
Iron Contributor
Jul 06, 2024
Try
strSQL = "SELECT DISTINCT [Project Database].[Status]" & _
" FROM [Project Database]" & _
" WHERE [Project Database].Country = '" & Me.cobCountry & "'" & _
" ORDER BY [Project Database].[Status];"
Gilmour10's avatar
Gilmour10
Copper Contributor
Jul 17, 2024

Hi XPS35, thank you for your help, I think I'm on the right path! 

 

cobStatus now presents only the choices in the 'Status' field of the data source that are available for the selected country! However, this happens when, after selecting the country I go and try to select the Status:

 

 

The system asks me to re-enter the country manually.

1. How do I eliminate that error? and

2. How can I filter the two other combo boxes based on choices made in the first two? What would the After Update event look like for Concept and Project Type? 

 

Thank you so much for your help!

Resources