• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

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

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.
James Coats
James Coats
  • 3
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Define what you mean by "don't work". What are they supposed to do, what are they doing, and what changes have you made?
Rey Obrero (Capricorn1)Commented:
you don't need an Option Group for this type of set up.

what is the purpose of the third Option button?
Rey Obrero (Capricorn1)Commented:
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
James CoatsComputer Info. Sys. StudentAuthor Commented:

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  ??
Rey Obrero (Capricorn1)Commented:
<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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now