add new record at top of form

  • Thread starter Thread starter jw
  • Start date Start date
J

jw

Hi,

I have a form with several combo boxes that fill in the
values from the current record to the next record. When
I am entering data, I get to the end of my computer
screen and must use the scroll bar continuously to move
the form so the next record will be visible and ready for
me to enter data.

I would like to avoid this constant scrolling by making
th new record appear at the top of the form (while
maintaining the feature of current record values
appearing in the new record).

I have tried creating a subform within my form. The
subform is identical to the form. I was hoping to be
able to do data entry in the form (one row) and to have
the subform show previous record and allow edits but not
additions.

This did not work as the form only showed one record but
upon enter would move to record two without showing
record one anymore. The subform did not show any records
upon entering the record in the form.

I would appreciate any suggestions! I included the posts
where I got this idea for reference below.



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.
 
Hi,

Thank you for your response! I already have the forms
Default View property to Continuous Forms and the new
record does not appear at the top, but at the bottom of
the page.
 
Thank you for your response! I already have the forms
Default View property to Continuous Forms and the new
record does not appear at the top, but at the bottom of
the page.
Click to expand...

This is the default behavior and cannot be changed. New records will always
appear at the bottom of a continuous form or a form in datasheet view.
 
Bruce said:
This is the default behavior and cannot be changed. New records will
always appear at the bottom of a continuous form or a form in
datasheet view.
Click to expand...


However, if you use two Subforms, the upper one can be set to adding a
new record only and will therefore only be one row high. The second
one can be the continuous Form that does not allow additions. Careful
placement will make them look as if it is one continuous form with the
blank new entry record at the top.

hth

Hugh
 
Thank you all for your responses! I think my problem was
trying to use a form with a subform instead of two
subforms. I will try that next. Thanks again!
 
Back
Top