Results 1 to 2 of 2
  1. #1
    Sheba is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    239

    Exclamation Forms - returning wrong value


    the radio buttons in my option group have option values 1,2, and 3 respectively. I have the following code:

    AfterUpdate event:
    me!hypo = choose(me.frame1, "Yes","No","Unknown")

    PS: hypo = table field name


    OnCurrent event:
    me.frame1 = switch(me.hypo = "Yes",1, me.hypo ="No",2, me.hypo ="Unknown",3)


    NOW in my table, I have value "-1" being returned! Could someone please advise what I'm doing wrong here?
    I need to fix this. Your help is greatly appreciated



  2. #2
    Sheba is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    239
    Just noticed that I had the data type on my table as Number instead of text! But since so many records have been entered. What would be the text equivalent of -1 I need to replace it with the correct data.

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

Similar Threads

  1. Returning wrong items
    By cbende2 in forum Access
    Replies: 5
    Last Post: 08-01-2014, 07:43 AM
  2. Replies: 4
    Last Post: 06-12-2014, 07:01 AM
  3. Count is returning the wrong count.
    By khughes46 in forum Reports
    Replies: 2
    Last Post: 05-26-2014, 12:46 PM
  4. Editing forms suddenly gone wrong
    By twinfair in forum Forms
    Replies: 3
    Last Post: 02-19-2010, 07:48 AM
  5. DMax returning wrong value
    By nedbenj in forum Access
    Replies: 7
    Last Post: 10-24-2007, 10:30 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