Subform contains inventory transactions by date. I want it to open so entry can be

[George Pollow]

made at the current date. It now starts at the oldest record.

[June7]

You want the form to open to a new record?

Can set the form to sort records in Descending order but the new record row will still be at the end of records.

[George Pollow]

I prefer to see the records in ascending sequence, like this:

TRANS DATE IN OUT
3/5/14 5 0
5/14/14 10 0
6/6/14

[June7]

Then I don't understand the issue. Ascending is default.

[Missinglinq]

If it's currently presenting the oldest record first, you must either have it sorting in descending order (which is not the default, as June7 suggested) and need to reset it to ascending order, or you're sorting on some other field, and the fact that it's currently presenting the oldest record first is coincidental.

Linq ;0)>

[George Pollow]

when I open a record the oldest transaction is highlighted. I want the line containing the current date highlighted so the user can enter the "new" transaction. Currently, we must scroll down to the current date.

[June7]

By 'to the current date' you mean the new record row is showing the date as default value? New record row will always be at the bottom, there is no way to change that. However, can use code to automatically move to the new record when the form opens or set form DataEntry property to Yes and only the new record row will show when form opens and existing records will not be viewable.

[George Pollow]

the transactions are showing in ascending order. I cannot find a sort option on the property sheet.

[June7]

That is the Sort By property of the form.

It will not alter the new record row position. It will always be at the bottom regardless of sort order.

[George Pollow]

I cannot find "sort by" on the property sheet. I do have "order by" which says "trans_date".

[June7]

Sorry, it is Order By. It is sorting by the field trans_date. Ascending is default. If you want the reverse:

[trans_date] DESC

[George Pollow]

I want ascending. But I also want the data entry live to be the current date (bottom of list)

[June7]

Are suggestions in post 7 relevant?

[George Pollow]

Yes. The "new record" row is on the botton and it shows the current date. But the oldest record is highlighted as the data entry line.

[Missinglinq]

Is this a Form or a Subform?

Linq ;0)>