How to Set a Field's Default Value in Microsoft Access. Default City, State, Zip, Today's Date.

In this video, I will show you how to set a default value for new customers so you don't have to type in data that's the same for most of them. If most of your new clients are locals, for example, you don't have to keep typing in city, state, and ZIP code. I'll also show you how to set a default value for the date to equal today's date.

Joanna from Key West, Florida (a Gold Member) asks: About 99% of my customers are locals. Is there any way to make it so I don't have to type in the City, State, and ZIP Code every time I get a new customer?

BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to use a form footer to provide that default value. This way if you want to enter a bunch of new records from, say, Florida, and then a bunch of new records from New York, you can set the default value in the footer, enter those records, then set the next one, and so on.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, what is default value, defaultvalue, set a field's default value, setting default values, now, date, today's date, default value based on another field, default value today, query default value, textbox default value

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[Esclarecidos]

There is a problem is CITY, STATE and ZIP come from a lookup to another tables. What to do in such situation? I tried the DLOOKUP function (in Default Value), using this formula, but always got an error message:
=DLookup("[FieldName]", "TableName", "[FieldID] = IDnumber")

[teribridges]

I joined but I am finding this less than helpful. If you are building his exact data base it works but tryin=g the apply any of this information to an existing data base is less than helpful. I think I will cancel my membership