Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form selection (2003)

    I have a form that is attached to a query (see attached). On the form they can select Rep last Name and Rep Number or ASM Last name and Asm number. What coding do I need in my query so they can enter either Rep infor or ASM info and not both?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form selection (2003)

    Change the criteria for Affs Rep La Nm 1 to

    [Forms]![Rep/asm input]![txtID] Or [Forms]![Rep/asm input]![txtID] Is Null

    and similar for the others.

    Note: the label for the third text box has a typo in its caption: "ASM Last Namer" (I assume you intended "ASM Last Name")

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form selection (2003)

    Yes, thank you for catching my error.

Posting Permissions

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