Sorting a column in a datasheet programatically

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi all,

I was wondering if it possible to sort a datasheet in a subform based on
dates in a column. For example, I have a subform that lists milestones
related to a task. On occasion a milestone is added that is dated before
some of the other milestones already associated with the task. When the
form is displayed I can select the Date column and right click -> sort
ascending/descending. I was wondering if there is a way of doing this
programatically?

Any pointers or tips would be appreciated,

Cheers
Rob
 
Hi all,

Sorted my problem by reading another unrelated post. Rather than base
my subform on a table, I have based it on a query and now have the
functionality I require.

This then lead me to another question. Is it accepted practice to base
subforms on queries rather than tables?

Cheers
Rob
 
Rob,

It is not only acceptable, but it is the most likely way to create your data
source.

You have many more options avaiable when you base any record source on a
query instead of trying to just use the entire table.
 
Back
Top