Combo box question

[[stav]]

Hi people.. I'm new here and new to access as well. Anyway..glad to b
member of this forum.

I use Access 2000 version and I have this question.
I want to have one combo box be determined by the selection in anothe
combo box.
How can I achieve this?

for example when I select Mercedes-Benz in one combo box to get i
another all the models of Mercedes-Benz ONLY.
and when I select BMW to get the models of BMW only.

also what if you want more than 1 combo box to change it's field
according to you r selection? how does this work?

thanks people.. I hope you can help m

 

[___]

Here's a quick example to help you along.

HT

+----------------------------------------------------------------
| Attachment filename: synchronised combo box sample.zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=157767
+----------------------------------------------------------------

 

[[stav]]

thanks a lot. I'll try it