Results 1 to 3 of 3
  1. #1
    Xterra14s is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Posts
    32

    Radio button in form


    Hello, I have a form that I just added a radio button into. When someone clicks the button I want it to update a table and change the Priority to Urgent. If the button is not clicked I want that field to stay empty. At the moment if I click the radio button its placing a -1 in the table instead of selecting the Urgent value. Any idea how to fix this?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    radio buttons are only numeric
    make radio btn unbound,
    in the radio_afterupdate event, set your values

    Code:
    if radio.value then
      [field] = "Urgent"
    else
      [field] = null
    endif

  3. #3
    Xterra14s is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Posts
    32
    Quote Originally Posted by ranman256 View Post
    radio buttons are only numeric
    make radio btn unbound,
    in the radio_afterupdate event, set your values

    Code:
    if radio.value then
      [field] = "Urgent"
    else
      [field] = null
    endif
    I got error saying Run-time error '424': Object required

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

Similar Threads

  1. Replies: 2
    Last Post: 03-29-2016, 04:52 AM
  2. Radio Button Question
    By data808 in forum Access
    Replies: 2
    Last Post: 05-10-2014, 01:27 AM
  3. Uncheck Radio Button?
    By taimysho0 in forum Programming
    Replies: 2
    Last Post: 06-29-2012, 03:44 PM
  4. Replies: 2
    Last Post: 01-08-2012, 12:07 PM
  5. radio button and checkbox
    By Fifa in forum Access
    Replies: 2
    Last Post: 01-19-2011, 10:20 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