Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there a command to go back to the top of a loop structure? 3

Status
Not open for further replies.

GZook

Programmer
Apr 14, 2003
42
0
0
US
I have the following loop in my program:
Code:
    lSkipEOF = 1
    Do While lSkipEOF = 1
        'Record specific variable initialization
  
        'No Tissue Quantity entered
        If Left(sTissueUser, 1) = "Y" And Len(Trim(sTissueQty)) = 0 Then
            lRetVal = MsgBox("Tissue User with no Tissue Quantity entered. Unable to Update Priority Field.", vbOKOnly)
            lSkipEOF = GMW_DB_Skip(lArea2, 1)
            ' How can I go back to top of this loop?  
            'Exit Do leaves the loop
        End If

        'Further Processing

        'Move to next record in CONTACT2
        lSkipEOF = GMW_DB_Skip(lArea2, 1)
    Loop

From within the If structure, how can I make execution go immediately to the top of the Do While structure?
 
Uh Oh, Looks like I've opened a real Pandora's box just by asking a simple question! lol! [bigsmile]
 
DrJavaJoe,

That's a good one. lol [bigsmile]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top