• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • 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 CoatsAuthor 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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