Lookup a value of another field in the same table 1

[splats]

Hello there

I have a table that has contact info. I would like the daytimeContact field to be a default value of the workPhone field. so that when a user types in a work phone number, it will automatically go into the DaytimeContact field. Is there a way to do this in the table? I would also like the user to have the option to change the daytime contact number field to another number if necessary.

TIA

 

[LittleSmudge]

In the WorkPhone_AfterUpdate event you can put :-


Private Sub WorkPhone_AfterUpdate ()

If IsNull(DayTimeContact) Then
DayTimeContact = WorkPhone
End If

End Sub


The If IsNull bit just prevents the code from overwriting an existing number in the case there the user has typed the DayTimePhone info in before getting to the WorkPhone
oh yes they could - you know they could !!!


'ope-that-'elps.



G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[splats]

thanks a bunch LittleSmudge

It works great!