Adding at top of Form

  • Thread starter Thread starter Rachel
  • Start date Start date
R

Rachel

There has to be a way to have users be able to add
records at the top of the form in tabular format instead
of the bottom. I have been through all the properties,
but cannot find it.

Creating a query will only display information in reverse
order. I need this feature.

Where is it or better yet, how can I do? I read
somewhere that I "might" be able to do it in a subform,
but HOW?

HELP!

Rachel
 
No, there is not a way to have the New Record row appear at the top of a
table, query or form. This is "by design".

If you want your users to have the "perception" that they are adding a
record to the "top" or wish to relieve them of having to click an AddNew
button or scroll to the new record row, you can do this with two subforms on
a main form. Briefly, here is how:

1. In design view, modify the Allow Additions property of your existing
tabular form to 'No'. Save this form.

2. Before you close this form, click File|Save As. You will want to save
this form to a new name; ie "MyTabularForm_AddRecords".

3. With the new, "MyTabularForm_AddRecords" open in design view, change the
Data Entry property to 'Yes' and the Allow Additions property to 'Yes'.
Save and close this form.

4. Create a new form which is large enough to hold your two forms. Click
the SubForm/SubReport icon and follow the prompts to bind this control to
your "MyTabularForm_AddRecords". Size the control as you wish. Click the
SubForm/SubReport icon again and draw a second subform control on your main
form below the one you just added. Follow the prompts to bind it to your
"TabularForm".
 
There has to be a way to have users be able to add
records at the top of the form in tabular format instead
of the bottom. I have been through all the properties,
but cannot find it.
Click to expand...

It's not trivial. Training the users is one option; if they (or you)
are resistant to that idea, try the following.

Create an unbound Form. Put *two* continuous subforms on it, based on
the same table, with the controls laid out in the same manner - create
one and copy it after you have the controls positioned.

Set the top one's properties so that Allow Additions = True, Allow
Edits = True, Allow Deletions = False, Data Entry = True; and set its
height so that only one row of data (the blank new record) is visible.

Drag the second subform up underneath this one, lined up so it looks
like one big subform. Set its properties to Allow Edits = True, Allow
Deletions = True, Allow Additions = False. This will let you edit or
delete existing records but will suppress the blank row at the bottom.
 
Back
Top