If Then Code help

[nobbie1]

I'm not very good with coding yet so I thought I would turn to these forums for some help.

I have a form for my technicians and when the form loads, the first thing they have to do is select their name from a combo box. I have some techs that are cross trained for 2 different areas, eventually we'd like to have all the techs be cross trained in both areas. I would like a message box to pop up with 2 choices, PEEM or DORNER and based on what is selected, will determine what choices can be selected in my subform depending on the area.

Hope somebody might be able to help get me started. Thanks

 

[wizcow2]

nobbie1

I think you want cascading combo boxes.

The first combo box would have a list of names.
Once a name is selected the second combo box (training) will have the appropiate choice(s)

Here is a link to a great explanation.

cascading combos

Good luck
Tom