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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.