By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,464 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Option Button on MS Access Form

P: n/a
I have created a form in MS Access 2000. The form retrieves... For
simplicity, let's say User Names... The form and text box is pretty
much setup for display only (the text box can not be edited). In the
detail section, next to the user_name text box, I have added an Option
Button.

The Option Button will give the person using the form the ability
to select only 1 user_name in the list. (Theoretically)

This is not what happens. The Option button in each row seems to
act as one button. When you select one, they all become selected. I
only want 1 row to be selected.
After this has been taken care of, I need to figure out within
code, which row was selected by means of the Option Button. This way I
can get the selected user_name.

Please help.... Thanks in advance.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Perhaps you'd consider using a listbox, instead of a continuous view form?
"Steven" <im****@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
I have created a form in MS Access 2000. The form retrieves... For
simplicity, let's say User Names... The form and text box is pretty
much setup for display only (the text box can not be edited). In the
detail section, next to the user_name text box, I have added an Option
Button.

The Option Button will give the person using the form the ability
to select only 1 user_name in the list. (Theoretically)

This is not what happens. The Option button in each row seems to
act as one button. When you select one, they all become selected. I
only want 1 row to be selected.
After this has been taken care of, I need to figure out within
code, which row was selected by means of the Option Button. This way I
can get the selected user_name.

Please help.... Thanks in advance.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.