Using One Field To Up-Date Another

N

Nick hfrupn

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
 
M

Marshall Barton

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
 
N

Nick hfrupn

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