Solved How to set set Sort Order by Entry Date and Time? (1 Viewer)

[JithuAccess]

Hello Guys,

I want to sort entries in my Form by Entry Time. So I have created a new field in the Table and set the current date and time as default value. Then I have make this Text invisible.

I want to display the latest Record when I open the Form.

Could you please let me know how to set this sort order in my Form?

Thanks

 

[pbaldy]

You can base the form on a query that applies that sort or use the Order By property of the form.

 

[theDBguy]

Hi. Just as a reminder, in case it applies, the DefaultValue property only applies to new records. So if you have any existing records, those won't have the date and time information in that new field. Cheers!

 

[JithuAccess]

You can base the form on a query that applies that sort or use the Order By property of the form.

Thanks a lot. It worked Perfect

 

[JithuAccess]

Hi. Just as a reminder, in case it applies, the DefaultValue property only applies to new records. So if you have any existing records, those won't have the date and time information in that new field. Cheers!

Thanks a lot

 

[pbaldy]

Thanks a lot. It worked Perfect

Happy to help!