Code:
=DLookUp("StaffName","tblStaff","Login='" & Forms![Logbook Form Continuous]!User & "'")
when i open Logbook Form Continuous Form ,
i have table "tblStaff" with:
*->[Login], [StaffName]
tdax Tim Dax
*-> there is a hidden field:
[txtModBy] = Environ("username")
what i am trying to do is that when i open form [Logbook Form Continuous] . Field [User] in that form will LOOKUP "tblStaff" and match the [login], to [StaffName] and then put the personnel name in [User]
<CENTER><TABLE cellSpacing=0 align=center cellpadding=2px width=50% ><TR ><TD CLASS="AccTBMain" border-left=1px solid colSpan= 3 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccTBInner" align=Left ><font color="White">tblStaff : Table</font></TD><TD CLASS="AccTBInner" align=right >Access 2003</TD></TR></TABLE></TD></TR><TR ><TD CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccHDRMain" align=left >Login</TD><TD CLASS="AccHDRMain" align=left >StaffName</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
![](/board/proxy.php?image=http%3A%2F%2FAccArr.gif&hash=03bae7dad5a5801553c6ac3013ddc6fe)
</TD><TD CLASS="AccDataElem" >bmartinez2</TD><TD CLASS="AccDataElem" >Ben Martinez</TD></TR><TR ><TD ID="currRec" CLASS="AccHDRLeftElem" >
</TD><TD CLASS="AccDataElem" >dreynolds</TD><TD CLASS="AccDataElem" >Denver Reynolds</TD></TR><TR ><TD ID="IE" CLASS="AccIEOnlyMain" colSpan= 3 ><TABLE width="100%" align=left VALIGN="TOP" ><TR ><TD CLASS="AccIEOnlyInnerRight" > Record: </TD><TD CLASS="AccButton" >
![](/board/proxy.php?image=http%3A%2F%2FAccNavL.jpg&hash=9297e74f32f64fc740698b0453c53353)
![](/board/proxy.php?image=http%3A%2F%2FAccNavR.jpg&hash=67f7a9885960860e5c7d2634b6babebd)