New record at top of list?

  • Thread starter Thread starter APH
  • Start date Start date
A

APH

Hi,

i have a subform which contains a list of records ordered by date in
decending so that newst is at top. Is there anyway to arrange the form so
that if the user wants to enter a new record, the blank reccord is at the
top of the list to save them having to scroll down to bottom of list?

Thanks

Alex
 
APH said:
i have a subform which contains a list of records ordered by date in
decending so that newst is at top. Is there anyway to arrange the form so
that if the user wants to enter a new record, the blank reccord is at the
top of the list to save them having to scroll down to bottom of list?
Click to expand...

You can use a form with a header or a subform to display an unbound record
at the top of the form. After the record is filled in, use code to append it
to the underlying table and requery the form's recordset.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top