Buttons on forms

[Betty]

Hello, all.

In forms:

How do I make a button that will save the entry, then clear the fields for a
new entry?
Also, how do I make a button that will save the entry, then close the form?

I'm ok with making a button to do one of those things at a time, but I can't
figure out how to make them do both when you click.

Thanks for your anticipated help!

 

[KARL DEWEY]

Have the button run a macro. Put all your commands in the macro.

 

[Betty]

EEEK! I'm a little afraid of macros. I'm new. BRAND SPANKING new. Any
other suggestions?

 

[KARL DEWEY]

The most harm you can do is to crash your database so backup oftem and learn.

 

[StrayBullet]

Another option would be to set up the button to perform the first function
(save the record) using the wizard.
Then, go to the OnClick event (the underlying vba) and add the second part
after the save command but before the end of the sub.
It should perform both tasks properly.

The most harm you can do is to crash your database so backup oftem and learn.

EEEK! I'm a little afraid of macros. I'm new. BRAND SPANKING new. Any
other suggestions?

[quoted text clipped - 13 lines]