One thing you can do is to make a single form with its Data Entry property
set to Yes. This means it can by used only for adding records, and for
viewing records added in the current session. You can prevent record
navigation for the most part by removing the navigation buttons. I will
call this form sfrmAdd.
Copy sfrmAdd as sfrmView. Change the Default View to Continuous, and Data
Entry to No. You can set Allow Additions to No to prevent using this form
to add new records, and to avoid the blank row that normally appears on a
continuous form. Set Allow Edits and Allow Deletions as needed for your
situation. Make it tall enough to show several records.
Add sfrmAdd as a subform, and sfrmView as another subform just below it. I
will call the subform controls (the "boxes" in which the subforms are
contained on the form) fsubAdd and fsubView. You can size the subforms so
they look like one continuous form, particularly if neither has a border.
sfrmAdd can have the table as its Record Source. sfrmAdd can have a query
based on the table as its Record Source, sorted as you would like. In the
After Update event of sfrmAdd:
Forms!MainFormName!fsubView.Form.Requery
When I have done this I have the users tab out of the last field to go to a
new record, but you could use a command button if you prefer. In any case,
requery in the After Update event as described. The just-added item in
sfrmAdd will show up in the continuous form.
They should not be entering data directly into a table. That's what forms
are for. In a table there is no way to do what you seek. In a form there
are a number of options, including seeing just one record at a time.
- Show quoted text -
Sorry I wasn't clear. That table is a subform on a form. So when
they open the form and find that table to enter data into I want the
first line blank so they don't have to scroll to the bottom.
Otherwise, there are daily entries they have to scroll through to get
to the bottom of the table. W