Solved How to create dynamic cascading combo boxes (1 Viewer)

[tihmir]

I am working on the following problem - I have a main table "tblAnimals" with fields "id" and "TypeOfAnimal". In that field "TypeOfAnimal" I have different types of animals - "dogs" with id 1, "cats" with id 2, etc. Then I have 2 tables of subspecies of these animals - "tblDogsSubspecies", "tblCatsSubspecies". The table "tblAnimals" is related with "tblDogsSubspecies" and "tblCatsSubspecies" field (foreign key) animal_id.
And the question is how to do the following: When I choose from combobox "cboAnimals" type of animal "dogs" the second combobox "cboSubspecies" to be populated with data from "tblDogsSubspecies".

 

[CJ_London]

You can't do this in a table, you need to use a form - see this link https://www.access-programmers.co.u...boxes-in-datasheet-or-continuous-form.275155/

 

[tihmir]

Thank you very much for the help, CJ_London!
I used this very useful method http://www.baldyweb.com/CascadingCombo.htm, as an addition:
If Me.cboAnimals = "Dogs" Then
strSource = "SELECT ......." & _
"FROM ......"

 

[CJ_London]

yes similar principle but only works on single forms - my example works in continuous forms as well