Add button

[jppigao]

Good day to you all,

I have another question that makes my work stop. I have created a form
and in that form i have some field to by filled up by the user, etc.
and some buttons for preview, print, closing the form and the "add
button". Now my concern is the add button because when i click the add
button it stop there, it do add the data into the database but what i
wanted to do is that, all the data will be save to the database, clear
all the data that has been entered into the form and most importantly
my cursor will immediately jump to the first field in the form so that
i can add another set of data.

Is this possible?

Please help me with my concern. Thank you in advance and God Bless.

John Paul

 

[Al Campagna]

John Paul,
I think your missing the idea of a New record.
When you edit or enter a record on a form, you are actually editing that
record in the table.
To add a new record, you do not delete the values on that record, and
fill in the new information. That would mean that you are covering over one
record with new data.
For example...
You are on the record for Bob Smith, and you want to add a new customer,
Jeff Jones. If you clear all the values on Bob Smith's record, and type in
the Jeff Jones information... all you're really doing is "covering over" the
Bob Smith information with Jeff Jones information. The Bob Smith data is
lost!!

To add a New record, you must go to a New (Blank) record, and enter the
Jeff Jones information.

DoCmd.GoToRecord , , acNewRec
--
hth
Al Campagna
Microsoft Access MVP
Candia Computer Consulting
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."