Results 1 to 4 of 4
  1. #1
    rohnds is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Austin, TX
    Posts
    7

    Option Button with Negated Value


    I have an option button on my main form. You click on the option button to display all the cars available. But in my table the available cars are stored "False".
    Is there anyway, I can change the values of the option button such that they work the opposite.
    For example, if I click on the option button, I want the value False instead of True and vice versa.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Am I to understand that you have bound yout Option Button to the Available field in your table? If so, have you tried to bind the control to Not([YourField])

  3. #3
    rohnds is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Austin, TX
    Posts
    7
    It is an unbound field. I like the option button to work the opposite. I intend to use the value using vba for something else.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So what code do you have in the option button that displays the available cars?

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

Similar Threads

  1. Drop down option?
    By kwy in forum Database Design
    Replies: 1
    Last Post: 06-02-2010, 12:13 PM
  2. Problem on Option Button
    By cwwaicw311 in forum Forms
    Replies: 2
    Last Post: 02-10-2010, 10:44 AM
  3. Replies: 6
    Last Post: 02-09-2010, 07:53 AM
  4. Option Group
    By huskies in forum Forms
    Replies: 9
    Last Post: 12-02-2009, 12:06 PM
  5. no option to import xls file or option all files
    By captgnvr in forum Import/Export Data
    Replies: 3
    Last Post: 09-22-2009, 10:19 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