Sorting issues-Need help bad!!!

R

reeve13

I am coming across a problem that I need help with.

When I enter a new record in the continuous form, Access places the ne
entry at the end of the DB and not in the correct slot. What I don'
understand is…before entering a new record, I do a filter by selectio
to bring up the records with that specific file number, and when
click on add new record, upon entering the new data and saving it, th
moment I remove the filter, the new entry is at the end of the db an
not with the others. I am very careful in entering the data to mak
sure it is correct, but whatever I do, the record is not update
correctly. How do I fix that?

Thanks. :confused
 
K

Klatuu

I believe what you need is to requery the form to get the records in the
correct order. Immediately after you remove the filter, add this line:
Me.Requery
 
B

BruceM

When you refer to the "end of the database" do you mean that it is in the
last row in the table? If so, not to worry. The table is a place to store
information, not to work with it. You can make a query, sorted as you
choose, based on a table and use that instead of the table for the form's
record source, or you can use a form's Order By property or a report's
Sorting property to arrange the data to your liking.
If this does not answer your concerns, please describe in a little more
detail what you are trying to do.
 
Top