Thanks Dave, an event macro sounds like exactly what I need but I'm
having trouble interpreting your code that you posted and applying it
to my form. I'll try and explain it a bit furthur, although it's
probably just me who's lacking the experience to alter it for myself..

The form I'm creating is not a list but a full landscape form that has
a couple of merged cells for the employee's ID number and another
couple of merged cells for the employee's name, so right away I hope
that identifies that I'm using Ranges for my two pieces of data. I
believe the ID number is A1:C1 and the name is F1:J1. Then I have a
completely seperate .xls file that is being used for the table of
values, column B contains the employee ID numbers and column D has the
names.

So when one of our payroll clerks punches in the employee's ID number
in A1:C1, what I'm hoping will happen is some sort of vlookup command
will search the table of values, then populate F1:J1 with the
employee's name. If the employee's ID number is not found, then the
payroll clerk has to manually enter the employee's name in F1:J1. I
know that if I stuck a Vlookup formula in F1:J1, I will either get a
matching name or #N/A after the ID number is entered. However if there
is no match, I don't want the payroll clerk to just delete the formula
and enter a name since the forms are on a shared drive. That's why I'm
trying to pursue a method in VBA, in which I have very little
experience.

I hope this all makes sense to help come up with something else.. or
maybe it's all for none and I'm just not interpreting the code
properly. Either way I would really appreciate further assistance with
my problem.

Thanks again,
Richard Garrett