Simple Option Buttons

[khashid via AccessMonster.com]

I have an URGENT but i guess very simple question. I would really appreciate
if someone can help.

I have a table with two fields, Name and score:

Now i want to have a form where :

Person enter's students name etc "ABC", infront of the name i want 3 options
(option buttons). Bad Good and Excellent.

User can only choose one button.

If user chose Good , in the table it would put good infront of the name.
Basically whatever user chooses in the option buttons, same thing would be
entered in the table infron of the name

I hope its easy, Thanks in advance

 

[SusanV]

Hi khashid ,

Add a textbox for your actual data field (in the table) to the form, and
after you test the code, set the visible property to false. Add an option
group with the 3 choices (the wizard makes this easy). In the frame's after
update event, use code similar to the following (assuming your textbox is
called txtBox and the options are Good = 1, Bad = 2 and Excellent = 3):

SELECT Case Me.Frame
Case 1
Me.txtBox = "Good"
Case 2
Me.txtBox = "Bad"
Case 3
Me.txtBox = "Excellent"
END SELECT

 

[khashid via AccessMonster.com]

Awsome, But where can i find the wizard?

Hi khashid ,

Add a textbox for your actual data field (in the table) to the form, and
after you test the code, set the visible property to false. Add an option
group with the 3 choices (the wizard makes this easy). In the frame's after
update event, use code similar to the following (assuming your textbox is
called txtBox and the options are Good = 1, Bad = 2 and Excellent = 3):

SELECT Case Me.Frame
Case 1
Me.txtBox = "Good"
Case 2
Me.txtBox = "Bad"
Case 3
Me.txtBox = "Excellent"
END SELECT

I have an URGENT but i guess very simple question. I would really
appreciate

[quoted text clipped - 15 lines]

I hope its easy, Thanks in advance

 

[SusanV]

On the form design toolbar, it's kind of odd looking - like a box with xyz
embedded in the top line., it's just to the right of the add textbox control
( ab| )
--
hth,
SusanV

Awsome, But where can i find the wizard?

Hi khashid ,

Add a textbox for your actual data field (in the table) to the form, and
after you test the code, set the visible property to false. Add an option
group with the 3 choices (the wizard makes this easy). In the frame's
after
update event, use code similar to the following (assuming your textbox is
called txtBox and the options are Good = 1, Bad = 2 and Excellent = 3):

SELECT Case Me.Frame
Case 1
Me.txtBox = "Good"
Case 2
Me.txtBox = "Bad"
Case 3
Me.txtBox = "Excellent"
END SELECT

I have an URGENT but i guess very simple question. I would really
appreciate

[quoted text clipped - 15 lines]

I hope its easy, Thanks in advance

 

[khashid via AccessMonster.com]

Sweet !! I did it, u r such a darling, if i get promotion you would be the
first one to know

But i still got one problem left, everything working fine, but when i choose
an option it puts the correct score in the text box but it does not put the
green dot in the option i choose. I believe i did something wrong while using
wizard,

Do i have to chose option "save it to use later" or "store it", i believe i
chose the wrong option thats why having this problem

On the form design toolbar, it's kind of odd looking - like a box with xyz
embedded in the top line., it's just to the right of the add textbox control
( ab| )

Awsome, But where can i find the wizard?

[quoted text clipped - 21 lines]

 

[khashid via AccessMonster.com]

I did it This time I used option " save it to use later" and it worked
fine... thanks very much

Sweet !! I did it, u r such a darling, if i get promotion you would be the
first one to know

But i still got one problem left, everything working fine, but when i choose
an option it puts the correct score in the text box but it does not put the
green dot in the option i choose. I believe i did something wrong while using
wizard,

Do i have to chose option "save it to use later" or "store it", i believe i
chose the wrong option thats why having this problem

On the form design toolbar, it's kind of odd looking - like a box with xyz
embedded in the top line., it's just to the right of the add textbox control

[quoted text clipped - 4 lines]

 

[SusanV]

My fault - I forgot to mention that part! Glad to have helped,

SusanV

I did it This time I used option " save it to use later" and it worked
fine... thanks very much

Sweet !! I did it, u r such a darling, if i get promotion you would be the
first one to know

But i still got one problem left, everything working fine, but when i
choose
an option it puts the correct score in the text box but it does not put
the
green dot in the option i choose. I believe i did something wrong while
using
wizard,

Do i have to chose option "save it to use later" or "store it", i believe
i
chose the wrong option thats why having this problem

On the form design toolbar, it's kind of odd looking - like a box with
xyz
embedded in the top line., it's just to the right of the add textbox
control

[quoted text clipped - 4 lines]

I hope its easy, Thanks in advance