MS Access: Forms, Option buttons not working after code changes

Posted on 2011-04-27
Last Modified: 2012-05-11
I had to change the Option buttons on the form “frmNewToolDataEntry” and now they don’t work. I also changed to the code for the buttons to what I thought it should be but apparently there is an issue with my code. Can someone please take a look at my changes.
Question by:James Coats
    LVL 84
    Define what you mean by "don't work". What are they supposed to do, what are they doing, and what changes have you made?
    LVL 119

    Expert Comment

    by:Rey Obrero
    you don't need an Option Group for this type of set up.

    what is the purpose of the third Option button?
    LVL 119

    Accepted Solution

    see this revised db

    the three Option buttons are independent of the Option Group
    they are all bound to their respective fields

    see the codes in the AfterUpdate events of the buttons

    Author Closing Comment

    by:James Coats

    The third option is for instruments that have been taken out of service due to damage or outdated instruments.

    Is this not still an option type of thing? I looked at the code you did and I better understand what you did I think.

    To do this you still used the option group wizard correct  ??
    LVL 119

    Expert Comment

    by:Rey Obrero
    <To do this you still used the option group wizard correct  ??>NO

    with the kind of table design you have, you don't need an OPTION GROUP.
    * i used your Option Group as display/container of the three option buttons

    you have to use three independent option buttons each bound to InUse and Inventory and OutOfService

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now