New record

[Floyd Forbes]

Hello,

Is there a way you can carry the same value automatically
to a new record in a field.

Floyd

 

[Matthew DeAngelis]

Hello,

Is there a way you can carry the same value automatically
to a new record in a field.

Floyd

What do you mean by carrying a value? Do you want to reference an
existing data source or simply have a default value display in new
records? You can make a default value for a field in the Properties
menu, so that the value will be displayed in all new records.

Matt

 

[Scott]

-----Original Message-----
Hello,

Is there a way you can carry the same value automatically
to a new record in a field.

Floyd


.

In the Code window, add the following line of code to the
AfterUpdate procedure.

Me![City].DefaultValue = """" & Me![City].Value & """"
When the user clicks the New Record button, the City
field in the blank record will show the previous value.