One Combo on another (1 Viewer)

[davey3389]

Alright guys,

Got a bit of an urgent one here!!

Basically I've been reading through lots of stuff and still cant' make sense of it alll

I've got a form called "Vehicle sub form" and in there is the fields "VRN", "make" and "model" basically make and model are drop downs menus which get there data from 2 tables one called "Make lookup" and one called "model lookup"

The make table only has car makes, but the model table has makes and models

What i need is when you select a car make the model only populates cars of that make

Many thanks,

Ben

 

[linskill]

I am no expert but I think this is what your after.
http://www.youtube.com/watch?v=pMiJHhjzC8Y

 

[Accessdj]

Man! I just joined and stumbled upon your thread which is the exact question/problem I've been struggling with for days. I would really appreaciate if you'll be willing to share how you manage to choose a 'Make' from a Combo Box & only have those "Models' be chosen in the 'Model' Combo Box. One thing different, I don't have lookup fields. I really hope to hear back from you...Dave