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