I saw posts in Dependent listboxes on access forms, which problem is very similar to my.
I’m working over to create an MS Access application.
I used in my project given code :
Code:
Code:
Private Sub Country_AfterUpdate()
With Me![Region]
If IsNull(Me!Country) Then ' if no country is selected
.RowSource = "" ' leave row source of Region blank