Dynamic Default Value: Use the Same Value For Multiple Records During Data Entry in Microsoft Access

In this Microsoft Access tutorial I'm going to teach you how to use the same value for multiple new records during data entry with something I call a Dynamic Default Value.

Silver members and up get access to an extended cut of this video. Members will learn how to automatically change the default value of the current new record when the default is changed and vice versa (change the default, default value when the new record is entered). Yes I know this all sounds very confusing but it makes more sense in the video. Watch it and I'll explain. LOL

LEARN MORE:

EXTENDED CUT:

LINKS:

RECOMMENDED COURSE:

BECOME A MEMBER:

FREE TEMPLATE DOWNLOADS:

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, Dynamic Default Value, Input the Same Data into Multiple Records, Entering data once for multiple records, Assign default values from the last record

[Jojosmith]

So cool ! This is what I have been searching all over the world. Thank you so much Richard for another excellent tutorials. All thumbs up 👍 as always before Richard's class even starts to motivate Richard to keep educating the planet earth. Richard is super awesome !

[youknow]

GREAT TIP! Working at an auto parts store years ago, we maintained our own inventory on a DEC-PDP 11-23 and this was always an option. For instance if an inventory item was from a certain vendor it would default to that vendor, we could change that as well.

[stuartround]

A couple of weeks back you were asking for suggestions for things to make videos about, and watching this has reminded me of something I learnt which helped to make my forms work much more nicely. Say you have a list of people in alphabetical order on a continuous form, and you want to remove some. So you work your way down the list to the "M"s, remove one, then obviously the form has to requery, and afterwards you're back at "A" again! It's really annoying. So I use the form seltop property to remember where I was at on the form and to return to that point after the requery. It's one of those easy things to implement that makes a database act like an application, rather than some quirky home-made thing. Just a thought!

[Jojosmith]

Richard save the world's mistakes by making mistakes purposedly in the video. More thumbs up 👍for honest great teacher of all time Richard Rost !

[tcoving]

This almost was exactly what I needed. I have a form/subform where a tax rate is shown in the parent, almost as a viewing pleasure.. the subform has all the records that I’d like to have auto populate from the parent tax rate. There are two tax rates that will depend on a “task code” =1000, otherwise 2nd tax rate ..that currently only shows as a combobox where the taskID is the bound column in the subform … any thoughts/remedies