I need to write a macro (a command button on a form
template) that will update a worksheet database and open a
new instance of the form at the same time. Any ideas?

Thanks!