Subform Question

[cwoody]

I have a sub form designed in form view for ease of use. When the main record set opens on the main form, the child set defaults to the first record in the set.My question:Is there a way of defaulting the veiw to the last record in the child set as default?
Any Suggestions would be gratefully received!!

 

[sfreeman@co.mer]

You could always reverse your sort order on the subform, that way you should see [presumably] the most recent, or last records entered.

 

[EileenL]

Subform

Is your subform data from a query? if so set the order in which you wish to see the records on the query for the subform data if it is a sql statement you will need to include in your statement the order and the field