Default Value of Field

[Novice1]

I have a field for a person's email address . In our organization the e-mail address is normally [email]firstname.lastname@airbase.af.mil

I'm trying to build a default value of . I tried ...

=[Fname] & "." & [Lname] & "@airbase.af.mil"

I placed the code in the properties of the field for the default value. However, when I pull up the record I only get @airbase.af.mil since the first and last name fields are blank.

Is my code right? When do I place it on the form? Thanks

Jim

 

[dcx693]

However, when I pull up the record I only get @airbase.af.mil since the first and last name fields are blank.

What exactly did you expect?