Adds records at top of form

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

I designed a form which shows records which include a date
in descending order. I added a command button for users
to click to add a new record. This sends them to the
bottom of the recordset (all the way under the oldest
date). Is there a way to leave all the records on the
screen and add the newest record to at the top of the form
(even though when refreshed it later may appear elsewhere
based upon the date the user enters in the record). The
users just need to see the most current records just below
where they enter the current record.

Thanks Everyone!
Good Day
 
Dawn said:
I designed a form which shows records which include a date
in descending order. I added a command button for users
to click to add a new record. This sends them to the
bottom of the recordset (all the way under the oldest
date). Is there a way to leave all the records on the
screen and add the newest record to at the top of the form
(even though when refreshed it later may appear elsewhere
based upon the date the user enters in the record). The
users just need to see the most current records just below
where they enter the current record.
Click to expand...
One way would be to create a form where the records are added and a subform
to show previous ones.
If they don't have to see all the fields in the old record this would work
well. If they do you could design a "tighter" form to show a continuous form
view of old records.
 
I designed a form which shows records which include a date
in descending order. I added a command button for users
to click to add a new record. This sends them to the
bottom of the recordset (all the way under the oldest
date). Is there a way to leave all the records on the
screen and add the newest record to at the top of the form
(even though when refreshed it later may appear elsewhere
based upon the date the user enters in the record). The
users just need to see the most current records just below
where they enter the current record.
Click to expand...

The only way I know to do this is to use a Form with two continuous
Subforms. The top form would have its DataEntry property set to True
so that you could see only the blank new record, or the most recently
entered record; make it one line high.

Immediately below it put a second subform of the exact same design,
but tall enough to see all the desired records; set its AllowEdits
property to True but its Allow Additions to false.
 
Back
Top