How to make dynamic fields on a outlook form?

[Shotgundave]

How to make dynamic fields on a outlook form?

Hi All,

I am creating a outlook form with dynamic dropdown menus. I have created 3 dropdown menus:

Eg:

Dropdownbox1 Dropdownbox2 Dropdownbox3
Data1 Data5 data9
Data2 Data6 data10
Data3 Data7 data11
data4 data8 data12

I want to create a dymanic menu so that if:

I selected 'data1' in 'dropdownbox1' I could only select 'data6' and 'data7' in 'dropdownbox2'

I hope this makes sence.

I imagine this is done using vba Does any one know how to do this?