Solved: #error

[Scooter172]

I have this expression in a form that when I enter the operators number it goes to the query "Full Name" and enters it in the Employee Name control in the form. How do I have the #Error not show up prior to selecting that number? Do I just add Or is Null? in the expression?

=DLookUp("[Employee Name]","[Full Name]","[Employee Number]=" & [Forms]![Daily Absence Entry]![Employee Number])

[fmcti]

Maybe you can give an inital employee number in the form such as 0. Then you shouldn't get an error after all.

[Scooter172]

used 0 as default, thanks