Do you need to do it via code?
If not, you can just right-click in the database window or go to File-Get External Data-Import, select the database, and then import the form. The form's module will be imported with the form.
If you really want to do it via code, look up the TransferDatabase method in Help.
HTH,
Russell