If the new table has the same name as the old one and the field
structure and definitions are the same and the security (if any) on
the table is added to the new table, same as the old one was,
then perhaps Yes.
The button code would only be for that form unless you copied it
and the code and made modifications for the new form name,
controls, and table, etc.
HTH
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.