need help to simply my code (LOOPING STATEMENT)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • darrel
    New Member
    • Nov 2006
    • 72

    #1

    need help to simply my code (LOOPING STATEMENT)

    Hi vb master i need help on this

    here my code:
    Code:
    If Combo1(0) = rs.Fields("TimeStart") And Combo4(0) = rs.Fields("TimeEnd") And Combo2(0) = rs.Fields("ROOM") And Combo3(0) = rs.Fields("DAYS") Then
                    cmdSave.Enabled = False
                    MsgBox ("There's a conflict on this!"), vbCritical
               
               Else
                           
               If Combo1(1) = rs.Fields("TimeStart") And Combo4(1) = rs.Fields("TimeEnd") And Combo2(1) = rs.Fields("ROOM") And Combo3(1) = rs.Fields("DAYS") Then
                    cmdSave.Enabled = False
                    MsgBox ("There's a conflict on this!"), vbCritical
               Else
                
               If Combo1(2) = rs.Fields("TimeStart") And Combo4(2) = rs.Fields("TimeEnd") And Combo2(2) = rs.Fields("ROOM") And Combo3(2) = rs.Fields("DAYS") Then
                    cmdSave.Enabled = False
                    MsgBox ("There's a conflict on this!"), vbCritical
               Else
    
               If Combo1(3) = rs.Fields("TimeStart") And Combo4(3) = rs.Fields("TimeEnd") And Combo2(3) = rs.Fields("ROOM") And Combo3(3) = rs.Fields("DAYS") Then
                    cmdSave.Enabled = False
                    MsgBox ("There's a conflict on this!"), vbCritical
               Else
    
                    MsgBox (" Good "), vbOKOnly
            
                End If
                End If
                End If
                End If
    i need to simplify this code of mine to make it short! i need to code it in a looping statement

    I hope you can help me with this.. thank you very much...
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    See my post in your other thread.

    Comment

    Working...