Use code to set value in record different from combo

[ringer]

I use a combo box to select a value from a list but I don't want what is selected to be written to the record. I need each selection of the combo box to correspond to another value that should be written to the record. For example:
Combo options from value list are Day(s), Week(s), Month(s), Year(s)
When Day(s) is selected in the combo box, I want "d" (w/o quotes) written to the record. When Week(s) is selected in the combo box, I want "w" (w/o quotes) to be written to the record. And so on.
Thanks.

[ringer]

Nevermind. Figured it out.

Row Source Type : Value List
Row Source : Day(s);d;Week(s );w;Month(s);m; Year(s);yyyy
Column Count : 2
Column Widths : 1";0"
Bound Column : 2

The 0" width for the second column hides that column.

[NeoPa]

Nice Ringer :)
Thanks for posting your answer and good luck with your project.