Me again,
Right now i am using a combo box, however i am trying to give each option a value as i cannot use it as a text value.
For example Autarch is one of the options from the combo box.
If the user was to select Autarch how would i create an IF statement from this, i cannot do IF HQ1 = Autarch as it is not an integer.
Thanks