I agree with Damian that a combobox makes much more sense in this situation
(or a listbox as second choice).
The 20 option limit is a limit of the wizard and not of the option group.
You can add more choices to the option group after the wizard creates the
option box with the first 20. Once the wizard has finished, click on the
option button or check box in the toolbar and then click inside the option
control (frame) - you will now have another option available. Repeat as
many times as you wish (there is an upper limit as to the number of controls
on a form.)
But with this many choices, I would suggest the a combobox makes much more
sense in terms of space required on the form and in terms of ease-of-use and
ease of modification.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
"Damian S" <(E-Mail Removed)> wrote in message
news:740B7942-78E5-4355-9056-(E-Mail Removed)...
> If you have 30 different product types, and it's only possible to have a
> single product type selected, you should have the product types in a
> lookup
> list (table) that is linked to your main table. Then you can have a
> single
> combo box to display your 30 items and the user can only select one. If
> you
> need a new product type, you simply add it into your table. Here's a
> sample:
>
> tlkProductTypes
> ProductTypeID autonumber
> ProductType text
>
> tblProduct
> ProductID
> ProductName
> ProductTypeID
>
> See what I mean?
>
> Damian.
>
> "PCH" wrote:
>
>> Hi damian
>>
>> I've got about thirty different product types.
>> If I insert a frame on a form and link-bound the option buttons to store
>> their vaule in the field say "product type" I can only use 20 option
>> buttons.
>>
>> If a split these groups into two, making two frames with fifteen option
>> buttons in each, I run the risk of entering "two values" into the
>> field...
>>
>> I was really looking to create a frame with as many options as I'd like,
>> where only one is selected and it's product group updated to the filed.
>>
>> "Damian S" wrote:
>>
>> > I am assuming your form is getting its data from the Product Group
>> > table. If
>> > so, place a checkbox on yoru form and set its data source to "Tube".
>> > It will
>> > then save the value into the Tube field of the Product Group table when
>> > someone clicks on it.
>> >
>> > Is this what you are meaning? If not, can you provide a little further
>> > information please.
>> >
>> > Damian.
>> >
>> > "Ashby" wrote:
>> >
>> > > Really it would be the same problem with the checkbox gining a
>> > > true/false
>> > > ,-1/0 answer...
>> > >
>> > > "Damian S" wrote:
>> > >
>> > > > Hi Ashby,
>> > > >
>> > > > Use a checkbox rather than an option button.
>> > > >
>> > > > Damian.
>> > > >
>> > > > "Ashby" wrote:
>> > > >
>> > > > > when an option button is selected I want to link it to a field in
>> > > > > a table
>> > > > > with a yes/no value
>> > > > >
>> > > > > ie
>> > > > > Table = Product Group
>> > > > > field = Tube (yes/no)
>> > > > >
>> > > > > if option button is selected then tbe = yes.
>> > > > >
>> > > > > How can I achieve this?
>> > > > >
>> > > > > Thanks Ashby
|
Similar Threads
