Looping through records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm building an XML file by looping through records in a table. Some records
may have a bad CustomerID that I've flagged earlier by appending a 1 to the
record.

I'd like the Loop to skip to the next record if it sees a bad ID flag. How
do I skip the current record and move to the next without completely exiting
the loop?

Thanks,

Todd
 
Todd,

Look at these two examples. Maybe they will help you. BTW, these are air
code....

'------------------------------------------------------
Sub WriteXML_1()

open recordset (rst)

DO

IF NOT (Bad_ID_Flag=1) Then
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to flag the lead ID of any contiguous ID's from a sorted list of ID's. 5
Loop through Table records 7
Loop concatenation problem 9
Loop through recordset with a twist 2
Append loop working but causing duplicates - I'm lost 3
Loop Question 2
Insert into loop not working 3
Loop through ADO recordset, update records, and count updated reco 1

Back
Top