the ever popular if>then statement

[John_G]

When you say the E-Mail field didn't populate - how did you check it? It won't populate if you just look at the record on the screen - you would have to type data into the first name and last name fields, and the E-mail will populate after you exit the LastName.


If you want the E-mail to update automatically when you are just looking through records, put the same code into the On Current event for the Form.

[June7]

As noted in post 10, code is not necessary. So if you want to spare yourself a headache, don't bother saving the value into table. Just calculate it when needed.

[sbrady19]

john, I did tab to the next field. I filled in the 1stname field, then filled in the lastName field, then tabbed to the email field, nothing happened.

[sbrady19]

here is my background. I am 54, I do audio post production for a living. I am a Mac user. I was made to use PC last year at work. I am trying to make a database for our company that tracks all our videos. We make over 700 a year, for the past 50 years. We have a need to find certain videos like:

a story in the USA, between 2min- 4min, about medical miracle, by a certain producer.

This forum has been incredibly helpful so far, sorry for my slowness. I'm learning Access as fast as I can.

I would love to be able to input the producers email in the field, when their 1st and last name is entered. I think I need a relational database to do this.

[June7]

Would you like to respond to my suggestion to NOT save this value to table - as presented in posts 10 and 17?