save new record with one form

[Travis (New User)]

I created a form to add several pieces of information to a table. I then
added a button at the bottom that I thought was suppose to save each record
as a NEW recod.

The problem is when I click the button it will save it as a new record, but
if I close the application and go to add a new record later it automatically
pops-up with the latest entry. I then just edit the information in the form
and it doesn't save the record as a new entry.... it saves it as the last
entry like I was editing.

How do either add code so it will always save as a new record or when I open
the form it will open blank and the button I've already added will work?

 

[Jeanette Cunningham]

Hi Travis,
would you post the code that saves each record as a NEW record.
Are you trying to make a copy of the record using the NEW button? Some more
explanation about what you are trying to achieve would be helpful.

Jeanette Cunningham

 

[Travis (New User)]

I have not input any code. I created the form in design mode and added the
button in the "design" tab. When you go through the wizard it says there is
a "add new record" button but it doesn't work exactly how I want it.

What I'm really looking to do is put a button on a form that will add the
information as a new record in that form to a table everytime you click it.

 

[Jeanette Cunningham]

Travis,
Access has some great features, and saving new record information into a
table is one of them.
The Add new record button is what you use after the user has entered all the
information for the current record, saved it to the table and when they want
to add the info for the next record they click the add new record button.
Clicking that button makes the form ready for the new record by having all
the textboxes blank or empty ready for the new info to go in.

Post back if you need more info.

Jeanette Cunningham

 

[Jeanette Cunningham]

Travis,
I think I missed the point with that last post.
When you create a form in Access, down the bottom of the form are the
buttons to go from one record to the next. The button on the RH end with the
star is the one you click to start a new record. Is this the button that
doesn't work for you?
If this button doesn't work and make the form go to a new record, we need to
check a few things about the form.
Let's know if this is what you are experiencing.

Jeanette Cunningham

 

[Jeanette Cunningham]

Travis,
usually when the user clicks the new record button, Access saves the record
in the table automatically before it clears all the controls (text boxes
etc) ready for the new information.
I say usually, because sometimes there are problems with the information
recorded for example that will prevent Access from saving the data and going
to the new record.
Is this what you are experiencing?

Jeanette Cunningham

 

[Travis (New User)]

The button works correctly. It will start a new record and save the old one.
I guess what I really am trying to accomplish is that I want this form to
ONLY open blank so a new record can be created. I don't need the form to
view already entered files. I am using a report to see the results of the
table.

My main concern is that a user will close the entire database and then go to
enter more data later. Then when you reopen the form, it automatically
displays the last entered information. I would like the form NOT to do this.
I want it to come up blank so there is no chance of the user accidently
saving over an already entered file.

I hope I have explained this better. Thanks again

 

[Jeanette Cunningham]

Travis,
open the form in design view.
If you can't see the properties sheet, click the properties button on the
toolbar at the top of the main window.
On the properties sheet go to the Data tab.
On the LH side is a list of properties.
Look for the one called DataEntry and you will find that it is set to No.
Change this property to Yes, save your form. Open the form to enter data, it
should be at a new record.

Jeanette Cunningham

 

[Travis (New User)]

Thank you so much. I just needed to explain what I wanted better. That
fixed the problem.

- Travis