Forms used for Updating a table

  • Thread starter Thread starter Greg Jesky
  • Start date Start date
G

Greg Jesky

I am new at this and feel dumber by the minute.
I have put some church records on to access 2000.
For example I have built a table that is supposed to have one record for
each month telephone bill. I built a simple form and entered the first
months data just fine. The table looked good.
The next months bill is now at hand, I go to my form and change the values
that need to be changed, and try to simply add to the table as record 2.
However it always overwrites record 1.
How do I simply use month 1 data with minor changes and establish record
2,3,4,.. on a going forward basis?
I have a book that indicates that I may have to build a Query first. However
my book does not show examples that look similar to my system.
Thank You,
Greg Jesky
 
Greg said:
I am new at this and feel dumber by the minute.
I have put some church records on to access 2000.
For example I have built a table that is supposed to have one record
for each month telephone bill. I built a simple form and entered the
first months data just fine. The table looked good.
The next months bill is now at hand, I go to my form and change the
values that need to be changed, and try to simply add to the table as
record 2. However it always overwrites record 1.
How do I simply use month 1 data with minor changes and establish
record 2,3,4,.. on a going forward basis?
I have a book that indicates that I may have to build a Query first.
However my book does not show examples that look similar to my system.
Thank You,
Greg Jesky
Click to expand...

When you open the form after your first record is entered you should have
navigation buttons at the bottom that indicate you are on "Record 1 of 1". You
simply need to press the >* button to go to a new record each time you want to
make another entry.
 
Back
Top