How to Open a Form and Go To a New Record and a Specific Field in Microsoft Access

In this Microsoft Access tutorial, I'm going to teach you how to open a form and go to a new record and a specific field. Then as a bonus, I'll show you how to set the description text of your contact form equal to the first 50 characters of whatever notes are typed in, if the user doesn't enter a description. Cool stuff. LEARN MORE: https://599cd.com/OpenFormNewRec PRE-REQUISITE: Intro to VBA: https://599cd.com/IntroVBA Contact Template: https://599cd.com/Contacts RECOMMENDED COURSES: Access Developer Courses: https://599cd.com/Developer LINKS Data Entry: https://599cd.com/DataEntry What is Null?: https://599cd.com/IsNull If Then: https://599cd.com/IfThen AfterUpdate: https://599cd.com/AfterUpdate String Functions: https://599cd.com/String TOPICS: OpenForm GoToRecord GoToControl BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, DoCmd.GoToRecord, acDataForm, acNewRec, DoCmd.GoToControl, DoCmd.OpenForm, open form to new record, Go to new record on opening form, How to open Form in Add record QUESTIONS: Please feel free to post your questions or comments below. Thanks.