G
Guest
I have some code which uses the values from a subform on a form:
the code is as follows:
If Forms![EMPLOYEE]![EMP subform]![APPRAISAL_STATUS] = "To Be Sent" Then
Emp = Forms![EMPLOYEE]![EMP subform]![EMP_NAME]
The above provides me with the value i require for the emp variable, however
what I need to know is when I have multiple names how do i get these accross?
the code is as follows:
If Forms![EMPLOYEE]![EMP subform]![APPRAISAL_STATUS] = "To Be Sent" Then
Emp = Forms![EMPLOYEE]![EMP subform]![EMP_NAME]
The above provides me with the value i require for the emp variable, however
what I need to know is when I have multiple names how do i get these accross?