Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Unanswered: *How to display a value and filter on it*

    I have field "Reply" as a option group and the values stored are 1= yes and 2 = no depending on the selection.

    Problem one:
    I want to be able to place the field on a form, having it display either "yes" or "no", not the numeric value stored in the field.

    Problem two:
    I need to be able to filter on "yes" or "no" in that field, not 1's or 2's, and get the correct results.

  2. #2
    Join Date
    Feb 2002
    in the after update event of the field reply you could use something like

    if me.reply=1 then


    Elseif me.reply=2 then

    Me.Somefield = "No"

    End if


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts