Unfortunately, Access doesn't give you triggers so you
can't use an add trigger (which is what you would use in
other mainstream DBs i.e. Oracle, Sybase etc). If you are
allowing the addition of data to the database using one
of your forms only, then add code after the record
addition code on your form to popup a msgbox to give the
user the choice of selecting whether they want to open
the transfer files form itself then and there.
Regards...