Keeping Track of data

[Prayder]

I have built a table off a form that is being used for record keeping and my question is.... This table will be constantly updated with new information so how can I make it to where when new info is added the old info will not be removed or written over?

 

[Galaxiom]

You design the data structure so that new records are added instead of editing existing records. The current data is returned by displaying the most recent records.

 

[Prayder]

Sorry,

I am very new and not sure I exactly understand what you mean?

 

[Galaxiom]

If you keep paper records you can choose to erase the existing information and write new values on the original records. Or you can write whole a new record on a new piece of paper when information changes and keep the old sheets behind it as an archive.

Much the same in a database except t is electronic.

 

[Prayder]

OK, so how do I make it in access where old info is not erased when new info is entered in the form that is connected to the table I built?

 

[Galaxiom]

Use VBA to copy the values from the original record to the new record, edit them and save the new record.

 

[kvar]

Set your form property to Data Entry: Yes.
That will make a new record each time you open it.

 

[brimah87]

I think you should go to the Suppot section of the official Microsoft Office website. I'm extremely new to Access too, and before I did anything I watched every single video on the official site. It really helped explain the ultra-basics for me.