Nz and #Error

[Pookiemeister]

On my form I have two textboxes. The values for these textboxes are being pulled from a query. In this query, there are two fields labeled Badge_ID and FullName. When a Badge_ID is entered into the first textbox, I use the DLookUp to locate the matching Name for that Badge_ID number and place the FullName of that employee in the EmpName textbox. I found a YouTube video that shows how to do that and it showed to put the following code in the "Control Source" of the EmpName textbox.

=DLookUp("FullName","FullName","Badge_ID=" & [EmployeeIDtxtbx])

The problem is when the form loads, #Error appears in the Employee_IDtxtbx. I saw another YouTube video that this can be fixed by using Nz (Null Zero) but I can't figure out where in that code to place it. Thank you.

 

[Micron]

That may not be the issue as the error usually means the name of something can't be resolved. Your query name and the fullname field have the same name? If not, that's the problem. If they are the same, then try
=DLookUp("FullName","FullName","Badge_ID=" & Nz([EmployeeIDtxtbx],0))
That assumes you want to return a zero if FullName is Null and that BadgeID is number data type.
FWIW I would not name a field and the table/query the same name.