Firstly, this is not as easy as it seems. A wheel mouse will also scroll through the records.
To disable the pg up & pg down buttons do the following:
On the forms load event add:
Me.KeyPreview.Enabled = True
Then the following:
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)...
Check the sample databases that should be somewhere on your PC. Check C:\Program Files\Microsoft Office\Office\Samples for files like Northwind.mdb
Or when you open access go file-new and select one of the custom made Db's
HTH
Dave
In the record source for the subform, select sort - decending in the field that designates the record as the newest (Id or date field etc) that will put that record at the top.
HTH
Dave
I have a small program that I think does what you need, but since I'm new to this forum I dont know how to add attachments. Email me at predator@impulse.net.au and I'll send it to you. (Or maybe let me know if and how you can post attachments)
Dave
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.