My database layout will include title-holder name, license plate #, color, year, make, model, insurance, and VIN.

At this point, I need only to design a userform for input. I have most of it done, and have come across no problems save for the make and model inputs. For the sake of error-checking, I thought it best to use a listbox or drop-down menu for each, with the model list dependent upon the input for make. (An input of Ford in the make field results in only Ford vehicles listed in the model list, similar to most auto-parts websites.)

For this specific situation, I don't know whether there is an easy, pre-made code for a data validation list that I could adapt, or whether I need to use a listbox and a bunch of case statements.

I must apologize. I don't know that I was communicating my question very well. The requirements for the project are known, and I hope that I have conveyed them adequately now. The layout, and most of the coding, is very easy. My problems are isolated surrounding the design of the list.

Thanks much,
Casey