Did you see xps35's "
Do not use macro's."
Use of word 'macro' when posting code must be because Excel people call vba procedures macros.
I have a Combobox on a form with 4 options,
How many columns does it have and if more than 1, which one is bound (or are any bound)?
You could put a break point in the procedure and check what the combo value is by mousing over the reference to it. Or you can type in the immediate window
?Me.Sales_Status_quoted
and hit return to get its value.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.