Results 1 to 5 of 5
  1. #1
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165

    Option Group Can't Change after initial selection


    How do I fix this? If I select an item in the option group, it locks the other items. I can't change it to something else.

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,474
    Are you turning AllowEdits off somewhere or locking/disabling that control or the form? Do you have any code in any of the Events of the form or that control?

  3. #3
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165
    No I just checked the form. There is nothing that disables edits. everything is set to yes. So I just figured out what the deal is. users are not able to change the selection unless they first select another field. So weird... i have no idea why

  4. #4
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,474
    So they can click one of the options, then it won't let them click another option, but they can click to another field, then go back and select another option and it works? This is all on the same record without saving anything, just changing focus on fields? If so, Odd.

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    So odd that it makes me wonder about corruption of the Control! Although we usually think of Forms or entire Databases when we speak of corruption, individual Controls, such as Option Groups, can and do become corrupted. The test and the fix are one and the same; deleting the Control then re-creating it! If it was corrupt, you've verified the fact and solved the problem! If not, you've only lost a minute or two!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Option Group selection
    By mahmud1180 in forum Programming
    Replies: 4
    Last Post: 10-10-2014, 05:42 PM
  2. Replies: 3
    Last Post: 12-02-2012, 09:38 AM
  3. Replies: 5
    Last Post: 08-13-2012, 06:57 AM
  4. Replies: 6
    Last Post: 09-27-2011, 04:39 PM
  5. Replies: 5
    Last Post: 05-17-2011, 11:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums