ComboBox to ComboBox automatic fill

[vbjohn]

Where can I find information on combobox to combobox auto fill?



What I mean is..
cmbStudy: (values) 1,2,3,4,5,6
cmbStudyTypes: (values) depends on what is selected from cmbStudy.


cmbStudy datasource is from a query
cmbStudyTypes datasource is also a query

[RayMilhon]

based on part 1 of your question I would've assumed that cmbStudy is the PK and cmbStudyType is a description for that. So I would've said set the sombobox to 2 columns with the bound column set to the PK and under column size set it to 0;2 (with the 2 based on the size of the description. However Looking at the 2nd part of your question it looks like the 2 combo boxes are based on different queries. Can you post the SQL for them? I could give a better answer then.

[rpeare]

What you're asking about is called cascading combo boxes where you want the results of a combo box to affect the available choices in a second combo box.

There are hundreds of articles about cascading combo boxes but the gist is that after you update or exit your first combo box you have to update the contents of the second combo box. Further, the second combo box must be a query based on the input from the first combo box. If you do a search on this forum (or google it) for cascading combo boxes you'll find what you want.