Enter record at begining

[slundrigan via AccessMonster.com]

I have a subform that is set up as a continuous form. To add a new record I
have to scroll down to the end to add a new record. Is there a way to have
the new records inserted at the begining rather than the end?

Thanks,

Stan.

 

[Damon Heron]

in the form's Open event, put
DoCmd.GoToRecord , , acNewRec

HTH
Damon

 

[slundrigan via AccessMonster.com]

Thanks for the reply.

On the current subform it lists the current entries in decending order so the
user can see the last entry. The problem is when they want to add a new
entry they have to scroll down to the bottom to add a new record. I would
like it to be at the top of the list.

Stan.

in the form's Open event, put
DoCmd.GoToRecord , , acNewRec

HTH
Damon

I have a subform that is set up as a continuous form. To add a new record
I

[quoted text clipped - 5 lines]

Stan.

 

[John W. Vinson]

On the current subform it lists the current entries in decending order so the
user can see the last entry. The problem is when they want to add a new
entry they have to scroll down to the bottom to add a new record. I would
like it to be at the top of the list.

There's no builtin way to do this. To simulate it, you need TWO
subforms: one with Allow Edits = Yes, Allow Additions = No, and tall
enough to display as many existing records as you want; and a second,
lined up carefully above this one, tall enough for only one line, with
Data Entry = Yes to show only the new record.

John W. Vinson [MVP]

 

[Damon Heron]

I am puzzled. My answer puts the new blank form as the visible entry ready
to be filled in with a new record. The user can then scroll up if they want
to see previous records. What am I missing? this is a continuous form,
right?

Damon

Thanks for the reply.

On the current subform it lists the current entries in decending order so
the
user can see the last entry. The problem is when they want to add a new
entry they have to scroll down to the bottom to add a new record. I would
like it to be at the top of the list.

Stan.

in the form's Open event, put
DoCmd.GoToRecord , , acNewRec

HTH
Damon

I have a subform that is set up as a continuous form. To add a new
record
I

[quoted text clipped - 5 lines]

Stan.