Access Lookup (Unbound) field in Form

[adams77]

I am receiving an error #Name? on a Form when trying to do a lookup from a customerid (perno) field.
I would like to enter a CustomerID on a form, the results after entering the CustomerID would pull the FName & LName from the tblSeniority. However, I am receiving an error. I have inserted 2 unbound text boxes on the form. I have placed the code in the Control Source: =DLookUp("FName",[tblSeniority],"Perno" & [Forms]![frmPending]![txtPerno] & "").

I am using MS Access 2010

Can you take a look at this and give me some direction.

Should I not put it in the control source and do son VBA?



Thank you in advance for all your help!

[pbaldy]

For starters, the table argument must also be in quotes. You also need an equals sign:

http://access.mvps.org/access/general/gen0018.htm

[Missinglinq]

And be sure to note the different syntax, based on whether the field Perno is Text or a Number.

Linq ;0)>

[pbaldy]

And be sure to note the different syntax, based on whether the field Perno is Text or a Number.

The link doesn't make that clear enough?

[June7]

Never know. I just went through interaction with a poster where they had explicit example for code and still messed it up.

[pbaldy]

So wait and see if that happens. Why repeat what's already been said if the OP hasn't responded that they're having trouble with it?

[adams77]

Thank you for giving me direction to the code! It worked just like i was hoping it would! Thanks again for all you do!