Probablay the most asked question. trying to return a value based on a lookup

[Tuckejam]

embarrassed to ask because i know it has to be one of the most asked questions but after 2 days i am still unable to solve this problem



I even found
=DLookUp("[Job Name]","[tbl_Job's]","[Jobs_ID]=" & [Forms]![frm_Incidents]![Jobs_ID])
but this just returns the error

#Type!

Basically in a form I want to enter a Job Number and have it show me the jobs name.

to go deeper, I am tracking delays that happen in the shop

so the main table and forms i have are "tbl_incidents" and "frm_incidents"

one of the supporting tables I have is "tbl_Jobs" and it has [Jobs_ID], [Jobs #], [Jobs Name]

but that is one of many things that the "incidents" is pulling in from other from other tables. it also has 'Employees" and "Customers" etc etc etc

and adding a Job #/name is not even required as not all delays are cause by or belong to a specific Job. but w add a job# I need it to show me the name)

thanks for the help

[Micron]

So what is the data type for [Jobs #] ? If it's text you need to delimit it with single quotation marks.
Do yourself a favour and eliminate, or at least going forward do not use, special characters like that in any object name (save for possibly underscore character).
And what is the form control that contains this parameter - a combo, or textbox, or something else? Last but not least, not sure when this is happening. Is it for records where there is no job number?

[ano]

1st a gud database id are numeric but we have no numeric fields in form
dlookup just put a valid # instead the textbox and an invalid # in direct window
and yes the single quote can be the problem as special character, just remove the ' from the name not realy needed a _

[xps35]

Are you sure the name of the table is tbl_Job's?

[Welshgasman]

You are not using Job# though, but it's ID?
The DLookup looks fine to me if ID is actually numeric?