Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    East Coast(USA)
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box (ACC 2K)

    I have a field called AppStatus with combo boxes (NEW, DSS, REDET etc.) field called EAPP with a data type Y/N. The only time EAPP checked yes is when the user select NEW or REDET. How can this be accomplished and where exactly ?

    Thanks,
    DD

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Combo Box (ACC 2K)

    In the after update event for the AppStatus field put this code:
    <pre>if ((me![AppStatus] = "NEW") or (me![AppStatus] = "REDET")) then
    me![EAPP] = true
    else
    me![EAPP] = false
    end if
    </pre>

    On the form you might also disable the EAPP control so that the user can't put the wrong thing in it.
    Regards
    John



Posting Permissions

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