combine 2 fields to make email address

[rgreene]

I've spent about an hour searching this site for email issues but most I found we how to send. I want to take existing data and make an email address.
I have a FName field and an LName field. In my email field I want FName.LName@email.com. the @email.com will always be the ending. Also where (on gotfocus) is the best place to put this code so it autopopulates after the FName and LName are entered?

Thanks!

Rick

 

[Matt Greatorex]

You can construct the full address using

str_Address = str_FirstName & "." & str_LastName & "@email.com"

Adding it to the 'AfterUpdate' event of the second field should do the trick.