Values in Option Groups

[Stephen Glynn]

If I've got a lookup table for various values and I'm laying out a form
with an option group in it, can I take the values for the option group
direct from my lookup table in Access 2000 or do I have to enter them
manually when I build the option group?

Steve

 

[Duane Hookom]

Option groups return a numeric value. I don't believe the option group
wizard will take advantage of the relationship to the lookup table. You may
need to set this up manually.

 

[Stephen Glynn]

Thanks. I knew option groups return a numeric value; I just wondered
if, having set up my look-up table with ValueNumber and Value, I needed
to re-enter them when building the form. Looks like I do.

Steve

 

[Steve Schapel]

Stephen,

Are you referring to the Labels of the Option Buttons in the Option Group?

By the way, as an aside, the word 'value' is a Reserved Word (i.e. has a
special meaning) in Access, and as such should not be used as the name
of a field or control.

 

[Stephen Glynn]

Sorry about using "values". What I've got is a lookup table with two
fields, which I probably should have called something like
'OptionNumber' and 'OptionLabel'.

What I ended up doing was making a note of these and then entering the
OptionLabels in the same order as they appear in the table when I used
the Option Group Wizard, and I just wondered if there was some way to
take the numbers and labels directly from the table.

I realise that if I'd used a combo box I could have done this very
easily but the person for whom I'm doing the form likes option groups
for some reason best known to him.

Steve

 

[Steve Schapel]

Steve,

Ok, thanks for the further explanation.

I am also a great fan of Option Groups, and use them often. However, I
have never used the wizard, and find it very easy to just set them up
manually.