New Records in Table go to top of table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with about 12 fields. Whenever I add a new record at the
bottom of the table, it goes to the top of the table until I close the table.
If I am interrupted after I put in a record, I have to scroll the the top of
the table to see where I left off. Please help. I think it must be a
setting. I want all records to go at the bottom of the table until I sort.
Thanks in advance.
 
Records in your table are not really stored in any particular order. You
should be working in a form, not directly in a table. Tables are storage
containers for records, they are not really user interfaces.

Create a form and sort the items the way you want.
 
Rick,

I created a form from the table and added a couple of new records in the
form. They went directly to the top of the list in the form also. I closed
the form and reopened it and they were then in order. There must be some
setting that is turned off or on that is making the new records go to the top
of the list until it is closed. Do you have any more ideas?
 
I have two tables in the database. I took a close look at the design of
each. One was working fine and the other had the problem with new records
going to the top of the table before saving. The only difference between the
two was that one had a space contained in the name of the table. After I
took the space out, the problem seems to be gone.
 
Back
Top