Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    139

    Red face Unanswered: Macro Expression using Yes/No Field

    I am trying to run a macro in a subform. In the macro are 3 macro conditions. 2 of the conditions refer to a field on the subform and run fine. The 3rd condition refers to the main form and the field is a yes/no field. On the form, I have the field displaying in a checkmark format. However, I do not believe this would have anything to do with the underlying table of yes/no. I have my condition set to if the warranty field on the main form equals yes the macro would run and then end the macro. This condition seems to open everytime.

    Could someone please look at my macro condition and see if I have written it properly. I have attached the macro.

    Thanks
    B&R
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2003
    Location
    Evansville, Indiana
    Posts
    76
    What if you say:
    Code:
    [Forms]![SR ORDER FORM]![WARRANTY]=-1
    The "behind the scenes" value of a Yes/No field is -1/0 respectively, so maybe the macro condtion is expecting to look at the actual integer value?

    Hope this helps.
    Kael Dowdy, MCSD, MCDBA

Posting Permissions

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