Saving Items from a List Box to seperate fields in a table

[dccjr]

First, thanks to all of you guys and gals who give your time to provide assitance and solutions to us newbies. It is really appreciated.



I have a listbox that contains one or more file paths. I would like to save each of these paths to a field in a table record. I am also copying the file itself to a central location. I have gotten this far, but am having syntax probelms.

For i = 0 To Me.lstAttach.ListCount - 1
           iAttachSQL = "INSERT INTO AttachmentFiles (File" & i & ")" _
           & "VALUES ('" & Me.lstAttach(i) & endSQL
           CurrentDb.Execute iAttachSQL
          FileCopy(Me.lstAttach(i), "X:\Operations\Manufacturing\Root Cause Analysis\RCADatabase\" & Me.tbxPartNo.Value & "-" & (i))        Next i

It is throwing a sytax error on my FileCopy line. I am guessing that it has to do with the (i) variable, but not sure how to correct it. Any ideas?

[June7]

Don't enclose the variable i within ().

[dccjr]

Ok, The line is

FileCopy(Me.lstAttach  i  ,"X:\Operations\Manufacturing\Root Cause Analysis\RCADatabase\" & Me.tbxPartNo.Value & "-" & i)

It now throws a compile error "Expected list seperator or )"

[dccjr]

OK, so I have decided to concatenate these before the FileCopy command, as such:

strFileName = "X:\Operations\Manufacturing\Root Cause Analysis\RCADatabase\" & Me.tbxPartNo.Value & "-" &  (i)
strListSource Me.lstAttach & (i)
FileCopy(strListSource, strFileName)

Both with and without the () around i, I am getting "Expected: ="
I must admit this way is cleaner, but still no better off.

[June7]

Sorry, I meant just the (i) at the end, not the first one, didn't even see it.

FileCopy(Me.lstAttach(i), "X:\Operations\Manufacturing\Root Cause Analysis\RCADatabase\" & Me.tbxPartNo.Value & "-" & i)

[dccjr]

Thanks. It works great now.