Show new Record at top of Datasheet form

[devagupt]

As of now the supervisors enter information into the packaging form . WHen they do , they have to scroll all the way to the end and start entering the information. The field names are on top and the information they enter is all the way at the bottom. They were wondering if they could enter the information from the top instead and at the same time have the remaining information displayed below so they would know what has been entered and what needs to be entered. Can this be done?

[NeoPa]

You can sort the records in reverse order, but I don't think you can enter the data anywhere but at the bottom (In record layout view anyway).
It may be possible using VBA and maybe using a separate form.

[MMcCarthy]

As of now the supervisors enter information into the packaging form . WHen they do , they have to scroll all the way to the end and start entering the information. The field names are on top and the information they enter is all the way at the bottom. They were wondering if they could enter the information from the top instead and at the same time have the remaining information displayed below so they would know what has been entered and what needs to be entered. Can this be done?

If they only need to see the data then you could create a new form set to form view instead of datasheet view and set the data entry property to yes. This will mean the form will be for adding new records only. You could then add the other form as a subform and this will show all previous records entered.

Mary

[MMcCarthy]

"The title of this thread has been changed to make the problem clearer to experts and others searching for similar threads."

MODERATOR