loop??

S

SIN

hi,
i have form with data that i check
i check the loop ' if i have 2 reord --> i have two turm to the loop, but if
i whant
to update the table:
if i have 2 record it update one.
if i have 3 record it update two.
example:
While Not (rsimportfile.EOF)
v_error_position = 6
If IsNull(Me!Invoice_Num) = True Then
sMyText = "The Filed Invoice Number Can't Be Empty. "
GoTo Exception
end if
Exception:
Me.Err_Code = v_error_position
Me.Err_Description = sMyText
rsimportfile.MoveNext
Wend
thanks
 

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

Prompt For Replace in Selection And More... 0
VBA word change keys 0
VBA works in orignal but fails in copy of database 1
Loop through and Update (INSERT INTO) 6
Loop through checkboxes 7
Connection String 2
Updateing a record with a Null value field, fails? 5
stuck in a loop 5

Top