Results 1 to 3 of 3

Thread: IF statement covering 2 textboxes

  1. #1
    Acolyte tigerdel's Avatar
    Join Date
    Aug 2012
    Location
    Cambridgeshire
    Posts
    29
    Articles
    0

    IF statement covering 2 textboxes



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have coded 2 textboxes to check for specific criteria and return results based on the state aof an option button.

    However, only one of them works {the first one - if I switch them around it is always the first statement that works}

    Grateful for some ideas to cure this:

    Code:
    If (optQ5_Result.Value = True Or optQ6_result.Value = True) Then
    txtBasic.Value = "Yes"
    Else
    txtBasic.Value = "No"
    If (OptQ1_Result.Value = True Or OptQ2_Result.Value = True Or OptQ3_Result.Value = True Or OptQ4_Result.Value = True) Then
    txtArab.Value = "Yes"
    Else
    txtArab.Value = "No"
    Last edited by tigerdel; 2012-10-13 at 08:20 PM.

  2. #2
    Code:
    If (optQ5_Result.Value = True Or optQ6_result.Value = True) Then
        txtBasic.Value = "Yes"
    Else
        txtBasic.Value = "No"
    End If
    
    If (OptQ1_Result.Value = True Or OptQ2_Result.Value = True Or _
        OptQ3_Result.Value = True Or OptQ4_Result.Value = True) Then
        txtArab.Value = "Yes"
    Else
        txtArab.Value = "No"
    End If

  3. #3
    Acolyte tigerdel's Avatar
    Join Date
    Aug 2012
    Location
    Cambridgeshire
    Posts
    29
    Articles
    0
    Simple as End If??

    Thank you so much

Posting Permissions

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