By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Show new Record at top of Datasheet form

P: 12
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?
Dec 11 '06 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,660
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.
Dec 11 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Dec 11 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
"The title of this thread has been changed to make the problem clearer to experts and others searching for similar threads."

MODERATOR
Dec 11 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.