markedback
MIS
I am building a form (linked to single table) that displays the employee details of an employee. It is supposed to work as follows - user enters a last name in the lastName textbox on the form and clicks on a command button that triggers the event procedure which displays the details in various other field like first name, manager name and so on.
I am using dlookup in the event procedure.
-----------------------------------------------------------
StrEmpNumber = Nz(DLookup("[EmpNumber]", "Emp", "[last_nm] = '" & Me![last_nm] & "'"))
-----------------------------------------------------------
I would like the form to display all the employees details when there are employees with the same last name.
Currently, the form only displays the one record for the last name entered.
Please advice if it is possible to do this.
Thanks,
Mark.
I am using dlookup in the event procedure.
-----------------------------------------------------------
StrEmpNumber = Nz(DLookup("[EmpNumber]", "Emp", "[last_nm] = '" & Me![last_nm] & "'"))
-----------------------------------------------------------
I would like the form to display all the employees details when there are employees with the same last name.
Currently, the form only displays the one record for the last name entered.
Please advice if it is possible to do this.
Thanks,
Mark.