I am trying to implement a button on a form (used
template wizard to link form to an excel list/database)
that will both save as "myfilename" and also force
the "create new record". So far, I can get it to save,
but the only way it will pop up the "template file - save
to database" input is by using the standard toolbar save
button. A save or save as macro will not bring up the
box.

I would also like it to pick the "create new record"
radio button, and click the "ok" box.

Is there a way to do this?

If not is there a way to make my button act exactly like
the standard toolbar button?

btw- I created a macro by clicking the std save toolbar
button, but it does not act the same, ie, I get no update
database.

tia
jason