New record at top of list?

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
 
A

Arvin Meyer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show last 'X' records in a subform 14
subform new record entry 1
Almost got it. Change order on subform After new record added 3
force new record to be at bottom of continuous subform? 4
How do I place the new record row at top of continuous form 2
Insert new record at top of continuous form 1
Sort certain records to top of list 9
Locate record in a subform 1

Top