Option Group

[bladelock]

I create an Option Group Name (Frame 159)
Control Source (Loc) with three values:

The option Group on the form is displays ED, EU, EZ.
However, when this saves to the table (which is a Text Field) it only stores
1, 2, or 3. I need it to Store ED, EU, or EZ in the Table.loc. How can I do
this?

I tried this in the AfterUpdate of the Frame159:

Me.Loc = Choose([Frame159], "ED", "EU", "EZ")

But it doesn't work

 

[Douglas J. Steele]

Is the field defined as a Lookup field? If so, then while it may look like a
text field, it's actual type is whatever the type of the ID field in the
table to which it's linked.

 

[Carl Rapson]

Is the option group control bound to the text field in the table? If so, you
need to unbind it. Otherwise, the value of the option group control will
always overwrite the value in the table.

Carl Rapson