This is the SQL:
Expand|Select|Wrap|Line Numbers
- SELECT
- A.RESOURCE_ID
- FROM tblWORK_DETAIL A WHERE
- A.BUILD_NAME = forms.cboBUILD_NAME
- AND A.WORK_DATE = (SELECT MAX(B.WORK_DATE) FROM tblWORK_DETAIL B WHERE
- B.BUILD_NAME = A.BUILD_NAME
- AND B.WORK_DATE = A.WORK_DATE)
Expand|Select|Wrap|Line Numbers
- txtLAST_RESOURCE.Value = DLookup("resource_id", "tblWORK_DETAIL", "MAX(WORK_DATE)=WORK_DATE AND " & "BUILD_NAME = " & cboBUILD_NAME.Value)
Eric