Using One Field To Up-Date Another

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

Guest

I have a form frmNewMembers and I record member’s first names in a field
FirstNames which I would like to copy into the next field PreferedName making
it easier to edit than type in the entire name.
I have no idea how to go about this as I have tried this in the Default
Value and doing a requery on exit of FirstNames field but no luck;
=[Forms]![frmNewMembers]![FirstNames]

Thanks any help appreciated.

Nick
 
Nick said:
I have a form frmNewMembers and I record member’s first names in a field
FirstNames which I would like to copy into the next field PreferedName making
it easier to edit than type in the entire name.
I have no idea how to go about this as I have tried this in the Default
Value and doing a requery on exit of FirstNames field but no luck;
=[Forms]![frmNewMembers]![FirstNames]
Click to expand...


The default value property is used only when a new record
first becomes dirty (generally the first keystroke), so
that's too late to be effective on the same record.

You can use some code in the firstname text box's
AfterUpdate event:

If IsNull(Me.txtFirstName) Then
Me.txtPreferredName = Me.txtFirstName
End If
 
Excellent this work well, thankyou very much

Marshall Barton said:
Nick said:
I have a form frmNewMembers and I record member’s first names in a field
FirstNames which I would like to copy into the next field PreferedName making
it easier to edit than type in the entire name.
I have no idea how to go about this as I have tried this in the Default
Value and doing a requery on exit of FirstNames field but no luck;
=[Forms]![frmNewMembers]![FirstNames]
Click to expand...


The default value property is used only when a new record
first becomes dirty (generally the first keystroke), so
that's too late to be effective on the same record.

You can use some code in the firstname text box's
AfterUpdate event:

If IsNull(Me.txtFirstName) Then
Me.txtPreferredName = Me.txtFirstName
End If
Click to expand...
 
Back
Top