Option Group help needed

  • Thread starter Thread starter gtslabs
  • Start date Start date
G

gtslabs

I am learning how to use Access after years of Lotus Approach. I
imported my database listings and have a question. I have a field
called "Status" with values 0,1,2,3. It was linked to a radio button or
I guess the equivalent of an Option Group now. 0 = Client, 1=Prospect,
2=Hot Prospect, 3 = Other. How do I make this work? I could not find
the "Optionvalue" the help file mentioned. I am working in Forms.

Thanks
 
I am learning how to use Access after years of Lotus Approach. I
imported my database listings and have a question. I have a field
called "Status" with values 0,1,2,3. It was linked to a radio button or
I guess the equivalent of an Option Group now. 0 = Client, 1=Prospect,
2=Hot Prospect, 3 = Other. How do I make this work? I could not find
the "Optionvalue" the help file mentioned. I am working in Forms.

Thanks
Click to expand...

An "Option Group" control on a form is a box which typically contains
a number of other controls - check boxes, radio buttons, or the like.
You can create an Option Group using the toolbox wizard (click the
magic wand icon).

Each internal control (button let's say) has an assigned value; the
Option Group as a whole is bound to the integer-numeric table field,
which gets the value of the button that the user selects.

What specific paoblem are you having? You're not trying to put an
Option Group into a *table* are you? Table datasheets are very
limited; use a Form instead.

John W. Vinson[MVP]
 
Hi,
I am using a form. I used the wizard to make the form with 4 options
and was able to lable the choices on the form.
But I dont know how to assign each option a value. I never saw the
"optionvalue" required. The help says something about a datalist or
something. I dont know what that is for or if I even need it.
I assume my option values are unbounded as nothing else is contingent
upon them. As I said each record has either a 0,1,2,3 in that field.
Thanks
 
Hi,
I am using a form. I used the wizard to make the form with 4 options
and was able to lable the choices on the form.
But I dont know how to assign each option a value. I never saw the
"optionvalue" required. The help says something about a datalist or
something. I dont know what that is for or if I even need it.
I assume my option values are unbounded as nothing else is contingent
upon them. As I said each record has either a 0,1,2,3 in that field.
Thanks
Click to expand...

Well, I really have no idea what you did. "4 options" on the Form?

Try using the Toolbox again. Click the magic wand icon; select the
"Option Group" control from the toolbox. You will get a series of
prompts: one will give you a little table in which you can enter four
(or more or fewer) labels; then another little table in which you can
assign a numeric value to each label.

John W. Vinson[MVP]
 
Back
Top