New Record on Top
By Richard Rost 12 months ago
Add New Record on Top of a Continuous Form
In this video, I will show you how to add new records at the top of a continuous form instead of at the bottom, which is the default setting.
David from Woodbridge, Virginia (a Gold Member) asks: I have a continuous form which sorts records by date with the most recent entries at the top. I have a button that allows me to add a new record, but it adds it at the bottom. Is there a way to add the new record at the top of the form?
Members will learn a more elegant solution by collecting the data in unbound fields, performing checks on that data, and then adding the record using SQL before requerying the form.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
There is a minor bug in the code in the extended cut. The following line should be changed:
I've updated the database download with the fix.
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, new record on top of continuous form, New record at top of continuous form, add new record at top of form, Continuous Form New Record at Top, gotorecord, acnewrec, requery, gotorecord, acfirst, gotocontrol, isnull, db.execute
Subscribe to New Record on Top
Get notifications when this page is updated
Check out these other pages that may be of interest to you: