How To Order After Insert

  • Thread starter Thread starter doyle60
  • Start date Start date
D

doyle60

I want a datasheet to reorder itself by [TypeNumber] and [Date] after
a new row is created. What is the code for this? I did it a long
time ago once and can't find it in my database. Thanks,

Matt
 
I want a datasheet to reorder itself by [TypeNumber] and [Date] after
a new row is created.  What is the code for this?  I did it a long
time ago once and can't find it in my database.  Thanks,

Matt
Click to expand...

you'd have to apply a filter (that only sorts)...
 
The only way I know is to use a requery.

Are you using a form in datasheet mode? A table or query datasheet has
no events that could be used.

Try putting me.Requery in the after update event of the form.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Thanks. Of course! Of course! Somehow I got it in my head that it
was a more involved thing to do. I like how it works best, in this
case, however, when putting it in the "On Input" property.

Matt
 
Back
Top