Incorrect order of data in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform in datasheet view in which i enter data,it is save
automatically in date/time order but randomly it saves in the incorrect date
order. A new entry will be saved in the list 2-3 days earlier but have the
correct date and time of data entry. If I open the subform without the main
form the data is in the correct order.Does Anyone know why and how to correct
this.
 
Is the subform based on a query or table? If on a table, try a query instead
and set the Order By for the date field as desired. You may also be able to
set the Order By property of the subform instead, if you prefer.
 
Back
Top