I am and advanced programmer and I am trying to create some DLookup in my database, this function is going to retrieve data for over half of the entries made. I have changed the code many different time base on the input of others and some threads I have found. I have checked ms help, but I continue to get runtime errors like invalid use of null and what not.
My current code is;
Me(Last_Name) = DLookup(Company, Customers, "Last Name" = Forms!JobOrderForm!Company_Name)
I am using the field "Last Names" on my "Job Order Form" to be the record ID to pull from. The record is in table "Customers" the data I want to receive is Company Name Phone number and extension (also the field names in the customer table)
The code is running on EXIT

 

---

Answer from Richard Rost:

I suspect it's probably not working because you aren't referring to your fields correctly, and you're missing a bunch of quotes and brackets. Try this:

Me!Last_Name = DLookup("Company", "Customers", "[Last Name]=" Forms!JobOrderForm!Company_Name)

Watch this tutorial on DLOOKUP:

You can use the DLOOKUP function to look up a specific value from a table or query.

Please see the following FREE video tutorial on my web site for step-by-step instructions on how to use DLOOKUP:

http://599cd.com/tips/access/dlookup-function?key=BlFAlEx