Duplicate Field from Previous Record - 2003

[oneilldm]

I can use Ctrl-' (apostrophe) to copy the value of the same field in the previous record.

I would like to create a Command Button that would do the same thing.

Is there a way to do that?

 

[wazz]

[COLOR=teal]'Set focus to the field's control.[/COLOR]
Me.YourControl.SetFocus
SendKeys "^(')"

 

[oneilldm]

Perfect... Thank you!!!

 

[missinglinq]

OR if you'd like to automate it completely, without the user having to do anything, you can use the AfterUpdate event of the control holding your data to set the DefaultValue for the field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each new record. The syntax varies slightly, depending on the datatype of the data:

For Date fields

Private Sub YourDateControlName_AfterUpdate()
If Not IsNull(Me.YourDateControlName.Value) Then
  YourDateControlName.DefaultValue ="#" &  Me.YourDateControlName & "#"
End If
End Sub

For Text fields

Private Sub YourTextControlName_AfterUpdate()
If Not IsNull(Me.YourTextControlName.Value) Then
  YourTextControlName.DefaultValue = """" & Me.YourTextControlName.Value & """"
End If
End Sub

For Numeric fields

Private Sub YourNumericControlName_AfterUpdate()
If Not IsNull(Me.YourNumericControlName.Value) Then
  YourNumericControlName.DefaultValue = Me.YourNumericControlName.Value
End If
End Sub

 

[oneilldm]

Very good... thank you!
I'll try that out.