Turning a subform datasheet upside down.

[Talismanic]

Is it possible to have the records that display in a subform added to the top of the datasheet instead of the bottom?

 

[Fornatian]

If I was trying to get the same result using continuous forms(and assuming you are using a list capable of sorting by date autonumber or other indicator I would:

1.Add a record in the background using recordsets and the .addnew method to add a new record to the forms recordsource.

2.Requery the form data to show the new record at the top.

3.Set the focus to the new record.

This would only be possible if I could provide all the required data during the recordset operation otherwise the record won't save.

I don't think there is an easy way to do it.

Hope this helps

Ian

 

[Fornatian]

If I was trying to get the same result using continuous forms(and assuming you are using a list capable of sorting by date autonumber or other indicator I would:

1.Add a record in the background using recordsets and the .addnew method to add a new record to the forms recordsource.

2.Requery the form data to show the new record at the top.

3.Set the focus to the new record.

This would only be possible if I could provide all the required data during the recordset operation otherwise the record won't save.

I don't think there is an easy way to do it.

Hope this helps

Ian