Options in a Form

[VickyC]

I am a bit of a beginner to Access 2003, and I would appreciate any help you can give me?

I have a drop down box on a form in Access 2003 with several options when an option is selected from the first drop down I would like a sub catagory of the selected drop down option to appear in the second drop down menu.

For example:

First drop down Hair, Clothes,

If you select Hair it then give the products relating to hair which need to be choosen in the second drop down menu.

I hope this makes sense.

 

[quest4]

Vicky, check out the attached form. It is a little different twist on what you are asking for. hth.

 

[VickyC]

That is great many thanks,

 

[quest4]

Your welcome, glad I could help.