473,696 Members | 1,609 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Option buttons allowing multiple selections

2 New Member
Windows 7 Access 2007

I am designing a database that has 6 items in a table. The items can only be one of the six. I am using Yes/No data type with textbox for the control. The query is using a Checkbox for the display control.
On the form, I created a sub form based on the query then changed the check boxes to option buttons. I got the buttons but it allows me to select multiple items instead of just one.

Someone PLEASE help me. I did this on another sub form and it works fine!
Dec 20 '15 #1
4 1928
5,501 Recognized Expert Moderator Expert
You have to place the option buttons in a group box. As you've discovered, what works with one record-set may not work with another. This depends entirely upon the tables/queries used for the record-source.

From the very little information we have, this isn't the design I would suggest for your form and from what little we have from your post it would be highly advisable to read thru: Database Normalization and Table Structures it appears that your overall database design could be (should be) tweaked just a tad.
Dec 20 '15 #2
2 New Member
I have the buttons inside a option group box.
Also neither set of buttons is working right. I am getting data in the wrong records.
If you want, I can post the striped down database.
Dec 20 '15 #3
215 New Member
your options button lets you multi checks mean something wrong.
may be your options button not on the same group ?
and maybe you want to data entry ? if that you have to put data entry property to true then your record'll move to new record, won't affect your current data

I suggest you to change your option control in vba like this
Expand|Select|Wrap|Line Numbers
  1. ...
  2. if me.controls("OptionBox's name" & i).value = true then
  3. Me.Items = choose(i, "item1", "item2", "item3", "item4", "item5", "item6") 
  4. end if
merry xmas
Dec 25 '15 #4
5,501 Recognized Expert Moderator Expert
1) I've re-read your first post six times now and what you have posted doesn't make sense from a database design. Hopefully there is more here than you've posted.

What I have is:
> One table
> Six records
> You can only have one of these records active at a time.
>> You are using a yes/no field to indicate the active record.

2) It sounds as if you added the Option-Group-Frame (OGF) and the option buttons (OPB) as separate elements on the form. Then either dragged the OPB into the OGF or dragged the frame around the OPBs.

In either case, the OPB will not become part of the OGF's control collection. There is an easy way to check this, show the property sheet, select one of the OPBs, the drop-down list in the property sheet should show this control in the drop-down list when either selected on the form or from the property-sheet's drop-list. Once the OPB's properties are showing, select the data tab. OPB that are part of an OGF's collection will have only three properties for data; "Option Value", "Enabled", and "Locked." OPBs that are not part of an OGF will have many more data properties such as "Control Source"

If your OPBs are not part of an OGF there is no easy way to correct this with the controls you have in place without either deleting and recreating the controls or using some fairly esoteric VBA to add the OPB to the OGF collection or a lot of VBA to duplicate the functionality of the OGF and provide that information to your record-set.

3) Before we go off on a "Wild Goose Chase" to correct this issue with code or redesigning your form - we will need a much better understanding of the goal/reason behind your database, what tables you have in the database, and how they are related to each other. If any of that (table being related to each other and how to do that) doesn't make sense then please read Database Normalization and Table Structures

All you need to post for us is something like:
Has field related to [TableName(s)]

Along with the over-all purpose of the database

For example (I'm only referring to tables here no field information, that may be for later, and this is a very simplistic example):

>Goal: Track orders and paid invoicing of products purchase by our customers.

[Customer_Addres sBook]
(this may have many related tables)

[Customer_Accoun ts]
Has field related to [Customer_Addres sBook]

Has field related to [Manufacture]
Has field related to [PColours]
Has field related to [PSize]
Has field related to [PackagingType]

Has field related to [Product]
Has field related to [Customer_Accoun ts]

>> PLEASE do NOT attach your database at this point in time. Normally this is not required to provide the needed assistance. Many of our Experts, myself included, work behind firewalls or with IT-Security that usually prohibit downloading such files.
Dec 26 '15 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Omey Samaroo | last post by:
I have had many questions answered in this forum and I am trusting that one of the readers may help me find a simple solution. (1) Using a field called Date_Hired (type: Date/Time), how do I use a label to display a value that checks the current date, Date() and minus it from the date hired to show tenure displayed as Years Months Weeks and days ? (2) How do I use multiple option buttons with only one selected and if so it stores a...
by: jeffgeorge | last post by:
Trying to create multiple acct reports based on the selection in a list box. I've set the list box for multiple selections, and in the report data source, I have a SQL statement which is reading the list box(when there is a single selection) but no luck with multiple selections. I'm suspecting I need to write a bit of code using an array. Does anyone have any insight or direction on how I might add?
by: Craig B. | last post by:
I am relativly new to access 2000 and am having some trouble with a report. I am not sure what I want to do is something I can do in access. I want to be able to choose from a combo box multiple selections in a form and from those selections present them in a report. For example select a selection A,B, and C out of 9 possible choices. Then show them seperated by a comma in a field in the report. I also want the option of only selecting...
by: Steffen Loringer | last post by:
Hi all, may be an easy question: How can I allow multiple selections in a dropdownlist? Thanks Steffen
by: antheana | last post by:
Hi there, I am trying to create a tblMailingList, but am a little stuck on multiple selections. The people that have opted into this mailing list will be given a list of different interests they want to be kept informed about e.g. services, special offers, 3rd party services etc. At any given time, If I create a newsletter for services, I want to run a query to extract everyone who has said they want to be kept up to date about services. I...
by: tbayse | last post by:
Hello, I have a question about making multiple selection queries in Access. I am running windows XP and Access 2003. Up until this point I had a form where a user would make single selections from a combo box and the following combo box would filter based on the initial selection. I now would like to give the opportunity to make multiple selections and the following combo box would filter based on that. How do I go about declaring this...
by: =?Utf-8?B?TGkgV2VuZw==?= | last post by:
Hi, Is there a way for TreeView to have multiple selections? But I am not talking about its checked boxes. I want a way similar to ListView with MultiSelect = True. So I can use or key and click to make multiple selections. Then when I simply click one item, all previous selections are gone. Thanks in advance.
by: Gunnar Hurtig | last post by:
Hi All I am relatively new to Tkinter and am putting a wraparound to the ATNF ASAP program. In one part I present several long lists in list boxes for selection. My code will remember the multiple selections made but I woul also like to highlight and maintain the highlighted items as I make additional selections. I can maintain the highlighted selections from listbox to listbox, but can't seem to figure out how to maintain the selected...
by: Germaris | last post by:
Hi there! Is it possible to make multiple selections in a ComboBox ? i.e. make n consecutive selections and store them in an array or make n selections in the open list of the CB by using (for example) the click-Shift Key keystroke Purpose is to allow the user to select multiple different issues of a magazine with a maximum ease of use... (Code I use is attached below) Many thanks for your help!
by: shirleymichael7 | last post by:
I am writing a VB6 web program for a Survey web site. They want 10 questions with each having 10 possible option buttons the user can select (like 1 is don't like, 5 is neither like or dislike, 10 is like very much). I can't figure out how to assign the 1-10 value to the option buttons then be able to retrieve it later per question to write the results to a database. Can anyone help me? This is probably very easy but for some reason...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.