Solved Hello everyone: After the dlookup process, I want to add the seriousness records to the top of the table

[Matin_Murad]

I want to send new records to the top of a table.. more clarification was written on a form

 

[plog]

I can't open your database--says I need a newer version of Access. However, I do know that no matter what version of Access you use (or any other database system) there is no "top" of a table. Tables have no order, they are just buckets of data you throw data into. There's no first, no second, no 38th record in a table. No record comes before or after another record in a table. The data is just in a table. Records don't go into a specific spot in the table, they either go in or they don't.

Now, when you pull data out of a table (with a query) or load them into something (a form or a report) you can specify the order in which they appear as long as you explicitly use code that provides the order they are to adhere to.

So, if you want them to display in a form in a particular order, you can use the OrderBy property of the form:

Change the filter or sort order of a form or report

Office VBA reference topic

docs.microsoft.com

 

[pbaldy]

I can open your db but I'll echo what plog said. You can do that by adding a "WhenSaved" date/time field to tabl2 with a default value of Now() and sort by that.

 

[mike60smart]

Hi Martin
I can open the database but I do not have a clue what you are trying to do here.

 

[Matin_Murad]

Sorry, I want to sort on the new record form to the top

 

[Matin_Murad]

Thanks for all the replies, it was helpful from the replies to the best solution