Change Value in Option Group

wdrspens

Registered User.
Local time
Today, 15:56
Joined
Jun 19, 2008
Messages
63
I feel rather foolish.
At the beginning of this year I designed a database form with an option group to which values were assisgned depending on the option selected - i.e. The option group is "Piano" and the options are "Not booked" with a value of 0, "Upright" with a value of 20, "Steinway Local" with a value of 40, "Steinway Professional" with a value of 100. I now want to change the value of "Steinway Local" to 50.
I cannot work out how to do this and my book "Access 2007 Inside Out" which says it is "the ultimate, in-depth reference" does not tell me how.
I am not using code other than that generated by Access 2007 itself, and am not happy with using code, so would prefer not to have an answer that requires me to delve into the use of code.
Any suggestions?
David
 
Don't run v2007, but in previous versions, in Design View, select he option button or checkbox itself, not the frame and not the button's label, open up the Properties window, and go to the Data tab. Change the Option Value property to whatever you want.
 
Thank you very much, brilliant, it works just the same in 2007. Very much appreciated.
David
 

Users who are viewing this thread

Back
Top Bottom