Why not just use the combo box with a two column array - and have the user choose 'Fabric', 'Lining', or 'Interlining'? Then store the F L or I in the table.


>I have a combo box on a form and a label next to it. When I change the value in the combo box I want it to refresh the label on the screen. For example My dropdown has 3 values F, L and I, When I click on F I want the label to say Fabric, when I choose L I want it to say Lining and when I select I it should say Interlining. Any ideas???
>
>Many Thanks