Bound Option Group

[Guest]

I have the following in an Access 2000 Database. The selection made for this
Option Group in 2000 is visible on the form even after closing and reopening.
Why when converted back to Access 97 is the selection invisible when closing
and reopening but data is in the table? Nothing has changed except for the
back conversion. Is there something that has to be diferently for Access 97?

Private Sub Frame157_AfterUpdate()
Select Case Frame157.Value
Case 1
[TYPE_OF_REQUEST].Value = "PROSPECT SURVEY"
Case 2
[TYPE_OF_REQUEST].Value = "IITIAL ACCOUNT EVALUATION"
Case 3
[TYPE_OF_REQUEST].Value = "UPDATE SURVEY/PRE-RENEWAL REQUEST"
Case 4
[TYPE_OF_REQUEST].Value = "ONE SHOT SURVEY"
Case 5
[TYPE_OF_REQUEST].Value = "ERGONOMIC SURVEY"
End Select
End Sub

 

[Guest]

Solved the issue. My After update needed Group.value

 

[Guest]

Hi,

I was having a problem with assigning text values to option buttons, i.e.

On my form, there are 4 option buttons...

Purple
Orange
Red
Double Red

each of which automatically had a value assign, 1, 2, 3, 4 respectively...

i wanted in the reports to show, the colour instead of the number... i.e.
"Red" instead of 3...

I tried using the case select statement, and in my table the colours, "red",
"orange" etc were appearing, but the form, the options did not stay selected
and records seemed to disappear on the forms but not in the table... sounds
confusing i know... :0(

I've pasted the code below,

[Amends] is the field in the table where the option group values are stored..

I'll be grateful for any help thanks :0)

Private Sub OptionGroup_AfterUpdate()

Select Case OptionGroup.Value
Case 1
[Amends].Value = "PURPLE"
Case 2
[Amends].Value = "ORANGE"
Case 3
[Amends].Value = "RED"
Case 4
[Amends].Value = "DOUBLE RED"
Case 5
[Amends].Value = "NOT A STICKER AMENDS"
End Select
End Sub

Solved the issue. My After update needed Group.value

I have the following in an Access 2000 Database. The selection made for this
Option Group in 2000 is visible on the form even after closing and reopening.
Why when converted back to Access 97 is the selection invisible when closing
and reopening but data is in the table? Nothing has changed except for the
back conversion. Is there something that has to be diferently for Access 97?

Private Sub Frame157_AfterUpdate()
Select Case Frame157.Value
Case 1
[TYPE_OF_REQUEST].Value = "PROSPECT SURVEY"
Case 2
[TYPE_OF_REQUEST].Value = "IITIAL ACCOUNT EVALUATION"
Case 3
[TYPE_OF_REQUEST].Value = "UPDATE SURVEY/PRE-RENEWAL REQUEST"
Case 4
[TYPE_OF_REQUEST].Value = "ONE SHOT SURVEY"
Case 5
[TYPE_OF_REQUEST].Value = "ERGONOMIC SURVEY"
End Select
End Sub

 

[Guest]

Thanks for the help so far.. but i found something on one of the other posts...

i put the following in the unbound text box (in the report) and it works :0)

=Choose([Amends],"Purple","Orange","Red","Double Red")

Thanks

Hi,

I was having a problem with assigning text values to option buttons, i.e.

On my form, there are 4 option buttons...

Purple
Orange
Red
Double Red

each of which automatically had a value assign, 1, 2, 3, 4 respectively...

i wanted in the reports to show, the colour instead of the number... i.e.
"Red" instead of 3...

I tried using the case select statement, and in my table the colours, "red",
"orange" etc were appearing, but the form, the options did not stay selected
and records seemed to disappear on the forms but not in the table... sounds
confusing i know... :0(

I've pasted the code below,

[Amends] is the field in the table where the option group values are stored..

I'll be grateful for any help thanks :0)

Private Sub OptionGroup_AfterUpdate()

Select Case OptionGroup.Value
Case 1
[Amends].Value = "PURPLE"
Case 2
[Amends].Value = "ORANGE"
Case 3
[Amends].Value = "RED"
Case 4
[Amends].Value = "DOUBLE RED"
Case 5
[Amends].Value = "NOT A STICKER AMENDS"
End Select
End Sub

Solved the issue. My After update needed Group.value

I have the following in an Access 2000 Database. The selection made for this
Option Group in 2000 is visible on the form even after closing and reopening.
Why when converted back to Access 97 is the selection invisible when closing
and reopening but data is in the table? Nothing has changed except for the
back conversion. Is there something that has to be diferently for Access 97?

Private Sub Frame157_AfterUpdate()
Select Case Frame157.Value
Case 1
[TYPE_OF_REQUEST].Value = "PROSPECT SURVEY"
Case 2
[TYPE_OF_REQUEST].Value = "IITIAL ACCOUNT EVALUATION"
Case 3
[TYPE_OF_REQUEST].Value = "UPDATE SURVEY/PRE-RENEWAL REQUEST"
Case 4
[TYPE_OF_REQUEST].Value = "ONE SHOT SURVEY"
Case 5
[TYPE_OF_REQUEST].Value = "ERGONOMIC SURVEY"
End Select
End Sub