copying files from "filelist" to destination folder

[princmode]

hi guys
this is my first topic here and iam really want your help
the following form( inserted as an attachment) is adding files from my computer to filelist
the issue here is that i want to copy the files which added in filelist to a specific folder which i choose

sorry for my english
thank u

 

[Ranman256]

in access, lists are controlled by a table.
the list is bound to it

so instead of using: Me.filelist.AddItem
make an append query:

insert into table (filename) values ('" & varFile & "')"
docmd.runSql

at the end, refresh the list: filelist.requery

 

[princmode]

in access, lists are controlled by a table.
the list is bound to it

so instead of using: Me.filelist.AddItem
make an append query:

insert into table (filename) values ('" & varFile & "')"
docmd.runSql

at the end, refresh the list: filelist.requery

many thanks for your reply
could u please edit the script for me cause i dont have enough knowledge about scripting in accesss