LATEST FIRST

[Guest]

Hi All,
I want to display my latest record first on my tabular form. When I use a
query to do this, it works fine. However, when I am adding a new record, is
it possible to have the cursor at the top of the bottom rather than the
bottom? In other words, is it possible to reverse the chronological sequence,
so that the newest record is ALWAYS at the top as I am writing the record?

 

[Steve Schapel]

Glint,

No, it is not possible to have the blank new record in a continuous view
form to appear at the top.

This behaviour can be simulated, however. You can put an equivalent set
of unbound controls in the Form Header, to mirror the data controls on
the form, with a little command button which will run an Append Query to
write the new data entered into the unbound controls into the table, and
then requery the form to have the newly entered record shown in the main
listing. Another similar approach is to put your existing form as a
subform on another unbound main form, and have another subform, just one
record, based on the same table, sitting above the other, and you can
use this for the entry of new records.