>Is there a way that I can have a different sort order on the grid in a form that is a parent and child form. (Chlidren are in the grid.)
>
>I would also like to set the order in descending order, i.e. with the most recent record first.
>
>Basically, one of the fields is a date field and I would like to show the user the latest record in the grid first.
>
>TIA,
>
>Mike

Ah, but if the grid source is the target of a relationship....

Then I would suggest that rather than using a relationship, you issue a query to extract the appropriate child records, in the necessary order, every time the user changes position on the parent table.