Results 1 to 4 of 4
  1. #1
    Probie is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2013
    Posts
    5

    Adding more than 1 expression in control source


    Hi, how do you add more than 1 expression in the control source

    I currently have =IIf([a]="x" And [b]="y","z","")

    I want to have the same thing but change x, y & z

    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    You can't, but you can have a more complicated expression. I saw your other thread, so rather than us try to hit a moving target, why don't you post your actual problem? Posting pieces of it may seem logical to you, but in reality the answer will often change with the question.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Probie is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2013
    Posts
    5
    Quote Originally Posted by pbaldy View Post
    You can't, but you can have a more complicated expression. I saw your other thread, so rather than us try to hit a moving target, why don't you post your actual problem? Posting pieces of it may seem logical to you, but in reality the answer will often change with the question.
    Thanks, I thought I would try try & figure it out first before asking but at times it looks confusing.


    What I wantb to do is make a Risk Management thing, a table with 3 Rows (Low/Medium/High) & Coloums Likely/moderate/Unlikely, I have set up these as values on a table as as you can see from the attachment when you choose something a corrosposinding note opens up, I want to put the risk number automatically into another box (See Risk Assessment Given Box), This will also go into a report.

    I have done it for 1 setting eg: High & Likely but can not seem to do it for the others moderate/Medium etc....

    Any advise would be greatful

    I hope I have emplained it easier enough
    Attached Thumbnails Attached Thumbnails Risk form.JPG  

  4. #4
    Probie is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2013
    Posts
    5
    After further searching & reading I figured out how to put more than 1 expression in I used the following:
    =IIf([a]="b" And [c]="d","e",IIf([f]="g" And [h]="i","j",IIf(k]="l" And [m]="n","o")))

    This seems to work

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

Similar Threads

  1. Help with Control Source
    By love2waltz in forum Access
    Replies: 1
    Last Post: 05-18-2012, 01:09 PM
  2. Replies: 5
    Last Post: 10-13-2011, 03:36 PM
  3. control source
    By nashr1928 in forum Forms
    Replies: 5
    Last Post: 03-12-2011, 09:31 PM
  4. Control Source
    By sarah54 in forum Access
    Replies: 1
    Last Post: 03-07-2011, 09:00 PM
  5. Textbox Control Source As An Expression help!
    By emilyrogers in forum Forms
    Replies: 11
    Last Post: 02-11-2011, 07:31 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