Thank you very much this worked perfectly. I added the following to the last field so that it would drop down to next record:
Case "Arrow6"
DoCmd.GoToRecord , , acNext
frm.Controls("Arrow1").SetFocus
Is there an easy way to detect if it is the last record so that I do not get...
I have a form with a subform which is in datasheet view. This is used to record archery scores and has six fields per row which will store values between 0 and 10. I have a set of buttons (10 - 0) on the main form and I would like to be able to merely click on the buttons and see the number...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.