I have a form in datasheet (Edit) view that is many records longer than the page height. The usual reason for the user to open this form will be to enter a new record, rather than amend an existing one. It would be neater and require less keystrokes if I can make the new record entry line appear at the top of the datasheet to avoid them having to (find and) click on the 'enter new record' control and then be taken to the bottom of the datasheet. Is this possible please?
-
-
What you can do is to just go to the new record when you open the form.Code:DoCmd.OpenForm... DoCmd.GoToRecord Record:=acNewRec
-
Thanks Seth, Yes I have now done that and it's certainly an improvement, but somehow it seems neater if the user is taken initially to the top of the numerically then alphabetically sorted list of records. Some of them will not be too conversant with the use of datasheets. Also, I use the form caption to describe what action is needed and it would be good if the blank record waiting to be completed was immediately below it. No big deal but if there is a relatively easy way of achieving it ....Comment
-
I don't believe that there is a setting that puts it at the top, but what you can do is to have some unbound controls at the top of your form and have the datasheet form as a subform. When you enter the new record information in the unbound controls and click an "Update" button, it would insert the new data and could requery the subform to show it. This would require some coding, but nothing too complicated.Comment
-
Thanks for your help Seth. I think I'll stick with the first solution.Comment
Comment