I have a userform that has a combobox for car makes, and I want to make
it so that when a make is selected, the box below it will be populated
with the models of that make.

I already have the makes populating the make comboboxes using ADO on
the UserForm_Initialize event.
I already have a table with all of the make/model info, there is a
column of models with a column that contains their makes, and to pull
the makes, i just SELECT DISTINCT Makes.

I tried making the ComboBox_change event connect and query the database
with the ComboBox.Text, but that causes all sorts of annnoying
ridiculously-hard-to-debug errors, and I am thinking that there must be
a smoother way to do this. Is there an event that occurs after the text
is changed and then idles? or is there a way I can make a combobox
intrinsically tied to an incomplete query, where the above box plugs
the missing link into the incomplete query and then connects and
retrieves the data?