Unbound fields value for comparison

[Minty]

Actually two strUpdate statement is different. The second one has one more criterium in where statement

You are still missing the point.
Put a break point on this line :

Next i

And when it reaches that point in the immediate window type ? strsql
Now press F8 and step through the code one line at a time, paying careful attention to what happens immediately after it exits the for loop.
Continue to press F8 and you will see that it gets to another

DoCmd.RunSQL strUpdate

and runs the last statement again.

 

[Wysy]

Thank you all for the kind help!