|
||||||
|
New Record on Top By Richard Rost 2 years 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? MembersMembers 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 files from class plus get access to the Code Vault. If you're not a member, Join Today!
Links
AddendumThere is a minor bug in the code in the extended cut. The following line should be changed:
To:
I've updated the database download with the fix.
Keywordsmicrosoft 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
|
||||||||||||||||||||||||||||||||||||
| |||
Keywords: TechHelp Access 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 PermaLink New Record on Top in Microsoft Access |