Fill in values from previous record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my form, I want the values of all fields to be filled in by values from
the previos record. I understand from another post that one way is to have
the following code written into 'After Update' property of a field, say
Campaign Name :
Me.Campaign_Name.DefaultValue = Me.Campaign_Name
but when I update the value of this field in a record and go to a new
record, the error displayed is ?Name in this field instead of the value that
I typed in.
How can I do it?
 
neeraj said:
In my form, I want the values of all fields to be filled in by values from
the previos record. I understand from another post that one way is to have
the following code written into 'After Update' property of a field, say
Campaign Name :
Me.Campaign_Name.DefaultValue = Me.Campaign_Name
but when I update the value of this field in a record and go to a new
record, the error displayed is ?Name in this field instead of the value that
I typed in.
Click to expand...


What you're using is only adequate for numeric values. The
more complete way is to use:

Me.controlname.DefaultValue = """" & Me.controlname & """"
 
Back
Top