Hi All,
I have a field called Secretary (which populates the loginID of the Secretary selected in the combobox - its record source is a query), and a field called Secretary UserCode. I need to automatically fill in the Secretary UserCode field in this format (FirstNameLastName), a combination of first and last name without any spaces. So using the same query where the loginID looks to, I created the Secretary UserCode (FirstName & LastName). When someone selects that secretary's loginID from the Secretary field, I need that Secretary's UserCode to be put into the Secretary UserCode field. Any suggestions?
I have a field called Secretary (which populates the loginID of the Secretary selected in the combobox - its record source is a query), and a field called Secretary UserCode. I need to automatically fill in the Secretary UserCode field in this format (FirstNameLastName), a combination of first and last name without any spaces. So using the same query where the loginID looks to, I created the Secretary UserCode (FirstName & LastName). When someone selects that secretary's loginID from the Secretary field, I need that Secretary's UserCode to be put into the Secretary UserCode field. Any suggestions?
