Mike is correct!
You can simulate what you want however in two ways.
Turn AllowAdditions off.
1. Place a row of unbound text boxes above your form for entering new records.
You can use a button or the AfterUpdate of the last textbox to:
a) Turn Allow Additions on
b) Add the contents of the textboxes to your table
c) Turn Allow Additions off
d) Requery your form to show the new record
e) Set all the textboxes to Null
2. Place a subform with Data Entry set to Yes, only one row displayed and
based on the same table above your form for entering new records. You can use a
button or the AfterUpdate of the last textbox in the subform to:
a) Turn Allow Additions on
b) Go to new record to save what was entered in the subform
c) Turn Allow Additions off
d) Requery your form to show the new record
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"John Baker" <Ba******@Verizon.net> wrote in message
news:3h********************************@4ax.com...
Hi:
I have a query which supports a form. Te form is used to edit, update and
change records in the table the query is based on. It all works fine EXCEPT that the "New"
record (blank updatable record) always appears as the end of the form (i.e. the bottom),
whereas it would be very helpful if it appeared at the beginning (the top of the form).
Can anyone suggest a way to make this happen?
Regards
John Baker