[HeavyBall]

I am using Docmd.TransferDatabase to archive tables to a backup database.

I have to identify the tables after the export, and would like the statement to name the exported table based upon values I enter into a form.

If I enter "purchasing" into a form I create, I want the docmd statement to use that word to name the table, such as,

DoCmd.TransferDatabase acExport, "Microsoft Access", "c:\a.mdb", acTable, "testtable", "'[forms]![input]' archived table"

This would name the exported table "purchasing archived table"

Does anyone know if I can name an exported table automatically?

 

[gsteve]

I would suggest that you look up the "DLookup" or "DMax" function in the Help section. I just learned to use this function, and it was just what I needed.