Overwriting the first table record - Help

vgarzon

Registered User.
Local time
Today, 15:48
Joined
Oct 17, 2008
Messages
30
Hi all,

I'm pretty new in Access 2007 and I've just created a table that needs to get data from a form (That I also created).

So, I open the form for the first time, entered a few data (I've used the "record Operations" --> "Add new Record" & "Save Record" buttons) and saved/stored them in the table with no troubles....

But that was only the first time... the second time on, When I open the form, it shows me the first record. I need that not to happen because when I write the data I need to put in the form and save it, it saves it as the first record... It always overwrites it... the other data that I enter, get into the table with no troubles, but this first record after reponening a form always deletes/overwirtes the first table record.

Could you tell me how to avoid this?

Thanks in advance
 
Try changing the Data Entry property of the form to Yes.
 
Thanks Paul. That was the answer I was looking for. Pretty basic, but if I didn't know....
Thanks again!
 
No problem; you can't know about something you've never seen!
 

Users who are viewing this thread

Back
Top Bottom