Buttons on forms

B

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!
 
B

Betty

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

KARL DEWEY

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

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.

KARL said:
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?
Click to expand...
[quoted text clipped - 13 lines]
Click to expand...
 
Top