>This is probably a dumb question to ask but if I have 5 option buttons and I wanted to save its value to a table, would I have to create five fields in table for each option button or just 1 field for all the option buttons to save option button value?
>
>
>Nick Patel

Hi Nick,

This is not a dumb question at all.

If the buttons are part of an OptionGroup control, your task is simple: you need only store whatever's in the Value property of the OptionGroup (not the button itself). If you initialize that value as character, you get the text of the selected button; if it's numeric, you get the (relative) number of the selected button.

If the buttons are separate controls, I would imagine that you'd want some code to look at those buttons, determine which one was selected, and store its Caption property (or some kind of code) to a single field in your table.

HTH.