[AccessD] SQL statement

On 5 Aug 2005 at 8:06, Kim Wiggins wrote:

> I'm sorry John, I didn't explain that well.  It is Quantity1, etc....  The (i) is the index in my program for me to loop through the fields.
> 
.....
> > I don't see anything. strSQL1 = "update tblRepairPartsReplaced set 
> > quantity (i) = '" & Val(txtQty(i)) & "' Where part_no = '" & 
> > txtPartsRep(i).Text & "'" Thanks Kim
> > 

If "i" is an index in your code,you can't have it inside strSQL1.  When you 
build the string, you have to resolve everything the way you do 
Val(txtQty(i)).  IOW you would need to replace "quantity(i) = " with 
something like "Quantity" & i & " = "


-- 
Stuart