Using Code to Delete a File

[bhujanga]

In my records I have a field that is a file name. This particular table comes up in a subform as a list, so that any of the photos in the list can be opened. I have a button next to each record that allows the user to delete that photo from the, so all the button does currently is to delete the record. I want to give the user the option to delete the photo file if they wish, but I can't figure out the code to use. I found this syntax:

object.DeleteFile filespec

but I can't figure out what to put in for 'object'.

Thanks.

 

[Remou]

Object in this case would be the FileSystemObject Object. You may also wish to look at Kill.

 

[bhujanga]

Kill" is just what I needed - much simpler than the other way. Thanks.