New record

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

Hello,

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

Floyd
 
Floyd said:
Hello,

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

Floyd
Click to expand...


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
 
-----Original Message-----
Hello,

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

Floyd


.
Click to expand...

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.
 
Back
Top