Add error message to a table?

[option]

Hey guys,

Quick question (I hope!): How would I take any error message that pops up in access (like Error 3024: File Not Found) and add that to a field in my table? I'm going through a table that warehouses all of the databases on my network drive and would like this info in my table for reporting purposes. Any ideas? Thanks!!

 

[KenHigg]

When the error is raised you can use error.description in a number of ways to put the text in a table/field, like executing a sql statement that appends a row, etc