Re: Date Field Order

[phillbaker]

Re: Date Field Order

I have a form with a text box in it where someone puts the date in. This was showing all the dates in order but now the most recent entry instead of going at the top is at the bottom.

How do i order them in date order. I have heard you can use the Order By option.

Can anyone help.

 

[namliam]

Any new entries will be at the bottom where you added them untill you "requery" the form.

Me.Requery will do that for you, you could use something like the "after insert" event to do that.