Hi,
I have a code to populate 2 dropboxes. The first one contains surnames, the second forenames.
The surnames are filled like this :
The forenames like this :Please Login or Register to view this content.
Surnames has a standard value, before clicking, "Achternaam", forenames has a standard value "Voornaam".Please Login or Register to view this content.
Now, what I would like to add to my codes is when you select one of the surnames, you only get corresponding forenames. And vica versa. So when Kind1AN has a value of "Achternaam" or "" (it might be you delete the value to restart and the default is gone too) and you select a forename in Kind1VN, Kind1AN is not populated with all the surnames in column H, but only with those who have a corresponding forename available in column I. Same thing when you first choose a surname, the list with forenames is filled with only those who correspond with that surname.
Thanks in advance
Bookmarks