Access Option Buttons on Form

[Ann]

Hi

If I have an Option Group on a Form with options for Tax
Rates eg: Option 1 20%
Option 2 40%
Option 3 Exempt
I would like when I click on the option in the Form that
this would filter back into my underlying table.

What data type would my field need to be and is this very
complicated to do???

thanks in advance for any help forthcoming!

Ann

 

[Eric Cardenas]

| If I have an Option Group on a Form with options for Tax
| Rates eg: Option 1 20%
| Option 2 40%
| Option 3 Exempt
| I would like when I click on the option in the Form that
| this would filter back into my underlying table.
|
| What data type would my field need to be and is this very
| complicated to do???
|
| thanks in advance for any help forthcoming!
|
| Ann
----------
Hi Ann,

You would probably use a number data type because I would assume that you
would use the numbers for calculation afterwards.

You would need some programming to convert option 1, option 2 and option 3
to be stored as 20%, 40% and 0 (exempt), respectively. You might want to
try a listbox instead to choose amongst the three options so you can avoid
programming code.

Hope this helps,

--
Eric Cárdenas
Access support


|