option groups

[hayden]

Im new to access
I used a wizard to create an option group and when assigning a value to each option i want a decimal (options for Discount) as i link it with the discount box so i can multiply it with the cost however it only allows whole numbers
any help be great

cheers

 

[gemma-the-husky]

no

an option group lets you select from a choice of options - radio button style - so that only one option can be selected at a time

each button has a value, 1,2,3,4 etc

and the value of the group as a whole corresponds to the choice made in the group.

generally useful for a small number of selections, similar to a combo bx or list box.

so option 1 could correspond to 2.5% disc
option 2 to 5% discount - but you would have oto do a bit of programming touse the value.


=============
its the sort of functionality you see in option pages in a lot of apps.

 

[SOS]

I would just store the discount percent in a table (so it can be changed if necessary) and then get the value with a DLookup (including you can set the captions of the option group items to match with the table values.