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:

PRE-REQUISITE:

RECOMMENDED COURSES:

LINKS

TOPICS:
OpenForm
GoToRecord
GoToControl

BECOME A MEMBER:

ADDITIONAL RESOURCES:

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.

[mikea]

Couldn't be better timing, I'm coming to the end of my first database project for my business and needed this for a couple of forms that I wanted to open as a new entry but still be able to select existing records. Thank you 👍

[gregskipa]

I love your videos. Always informative, usually relevant, and whimsical enough not to put you to sleep. I keep waiting for the next Star Trek reference...

[blaker]

First off, thank you tenfold for the help. We just discovered Microsoft Access for the company I work for, I was tasked with building a database that we can use, well, here I am a week in and a website membership and HOURS spent watching your videos!!!

My question is, is there a way to go to a blank new 'VehicleF' I want a button on our menu to add a new vehicle to our fleet, then I can replicate this for trailers, heavy equipment and mowers too! I hope my question is detailed enough, I think you should understand what I am trying to achieve! :)

[moodkn]

Very Helpful & Improving for Data Entery Video.
Lot of thanks Sir!

[cruzinsweetsntreats]

This will help me with 2 logs that I hadn't been back to in a couple of weeks: mileage (critical for taxes) and refuel. I had stopped looking for a proper method to jump to the *end of record set* to continue it on. Of which, I have the default date for a new record, set to use the last record, so I can easily enter the older data by changing just the numerical day.

[petewarby]

Endless learning, brilliant channel!!!

[vhuoelr]

Dir Mrs Richard, l wait to your videos everyday. You have a good way to make every thing easy, please keep that way.
I have question about your beginner level 2 please. Why you stopped ?! Sorry if I'm bothering you.

[celestebird]

Thank you!!! I love your videos, you have helped me so much!

[stephenbeswick]

Hi Richard that was very interesting in this video great steve

[andrewgresham]

Thanks - great courses and great tech help!

[KeirBriscoe]

Cant get this to work. The Single subform opens and looks like a new record can be entered. But Neither maintableID or the subtableID fields have data. So the new sub record is not linked to anything and generates an error when I try to close the subform. Ive gone over this tutorial many times and still no luck. Does this tutorial only work if the subform is continuous?

[javatea]

Hi there. I need help please. I need to select the new record on a subform where data will be filled in. My form is already. Any suggestions please. Thanks