I am new to creating forms with Access 2007. I am trying to create an option group with three option buttons. It is bound to a text field (Color) that has the look up set with 'row source type' = Value List and my three values listed in 'Row Source'.
Let's say the three possible values are Red, Green & Blue. When the user clicks one of the radio buttons, I want the text value of Red, Green or Blue stored in the Color field. However, it seems like an option group will only store numeric values (1,2,3 etc.).
How can I have an option group that stores actual values in the table? (Note: would prefer a non-VBA method if possible).
Thanks.
Let's say the three possible values are Red, Green & Blue. When the user clicks one of the radio buttons, I want the text value of Red, Green or Blue stored in the Color field. However, it seems like an option group will only store numeric values (1,2,3 etc.).
How can I have an option group that stores actual values in the table? (Note: would prefer a non-VBA method if possible).
Thanks.