Simple Requery question

[Muzicmn]

Hate to ask such a simple question but i am lost

scenerio: DB has fields: Last, First, address, Spouse_last, etc ...

my task is to have the Spouse_last field automatically match "Last" after it has been updated, to avoid having to retype same info. At the same time have the ability to change the Spouse_last, in case it is different

I know i have to add the code on the "After Update" field of "Last" but cant figure it out

appreaciate any help with this one

Ricky

 

[Pat Hartman]

Add this code to the AfterUpdate event of the last name field.

If IsNull(Me.[Spouse_Last]) Then
    Me.[Spouse_Last] = Me.Last
End If

 

[Muzicmn]

Thank you Pat,

works like a champ

I owe ya ! ! !


Ricky