Greetings,
I’d like to auto populate a textbox (txtDAUEmail) based on selection made in a combo box (cboDAUNM):
If John Doe1 is selected from the combo box, then the textbox should auto fill the analyst’s e-mail address. e.g. John.Doe1@emiladdress.com
I changed the row source of the combo box to CALCULATE the email address:
Result:
USERID INVNM PWD Email
001 John Doe1 **** John.Doe1@emiladdress.com
002 John Doe2 **** John.Doe2@emiladdress.com
003 John Doe3 **** John.Doe3@emiladdress.com
TIA
I’d like to auto populate a textbox (txtDAUEmail) based on selection made in a combo box (cboDAUNM):
If John Doe1 is selected from the combo box, then the textbox should auto fill the analyst’s e-mail address. e.g. John.Doe1@emiladdress.com
I changed the row source of the combo box to CALCULATE the email address:
Code:
SELECT tblLOGIN.USERID, tblLOGIN.INVNM, tblLOGIN.PWD, IIf([INVNM]=” John Doe1”,” John.Doe1@emiladdress.com”,Iif([INVNM]=” John Doe2”,” John.Doe2@emiladdress.com”,Iif([INVNM]=” John Doe3","analyst3@ John.Doe3@emiladdress.com ",""))) AS EMail
FROM tblLOGIN
WHERE (((tblLOGIN.PWD) Like "ad*") AND ((tblLOGIN.STATUS)="A"))
ORDER BY tblLOGIN.INVNM;
Result:
USERID INVNM PWD Email
001 John Doe1 **** John.Doe1@emiladdress.com
002 John Doe2 **** John.Doe2@emiladdress.com
003 John Doe3 **** John.Doe3@emiladdress.com
TIA