Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Records in table

Status
Not open for further replies.

FrankMars

Technical User
Dec 20, 2010
67
US
I am a (clueless) beginner with Access. After I fill out several records using a form, I go to the main table and only see the last record I entered. The table doesn't seem to accumulate records. What the heck? Thank you in advance.
 
How are you filling out several records?

You have to make sure that when you start with the new record, that it's actually on a different record, else you'll be overwriting everything again... and again... and again... all in the same record.

Did you design the form, or are you the one who is maintaining it, or what?

If you can make changes, then make sure the tab order is set in a logical manner, so when you tab out of the "last" data field, it automatically goes to the next record.

Another thing to do is make sure the Form's Data property, Data Entry is set to true. That way, it'll always be set to a new record when you open the form.
 
Thanks kjv
Your exactly right, I was overwriting everything again... and again... and again. I've got it now, you've led me out of the woods! Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top