dlookup

G

Guest

=Dlookup ("[Support Area]","[ Lima Caller Mapping Tables]","[System ID]="
&Forms!Form B_W Master Data!MachineID)

Could someone look at this formula and tell me where i'm going wrong....

Thanks in advance
 
D

Duane Hookom

There is a space to the left of "Lima..." Your expression also assumes
System ID is numeric.
 
J

John Vinson

=Dlookup ("[Support Area]","[ Lima Caller Mapping Tables]","[System ID]="
&Forms!Form B_W Master Data!MachineID)

Could someone look at this formula and tell me where i'm going wrong....

Thanks in advance
Click to expand...

Using blanks (especially leading blanks!!!) in form and table names,
and not using brackets appropriately. Does your table Lima Caller
Mapping Tables actually have a blank in the table name before the L?
Surely not! The blank in the form name is being interpreted by DLookUp
as the end of the string - it has no idea what Forms!B_W might be, and
the strings "Master" and "Data!MachineID" are just hanging out there
loose. Any time you have blanks or special characters in a name, you
must use brackets to delimit the name.

Try

=Dlookup ("[Support Area]","[Lima Caller Mapping Tables]","[System
ID]=" & [Forms]![Form B_W Master Data]![MachineID])

and consider simplifying your object naming convention.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dlookup Syntax 4
DLookup Help 4
Access ACCESS DLOOKUP INVALID USE OF NULL 0
Invalid syntax in dlookup 4
field that checks if the primary key value appears in a related ta 3
dlookup using variable as criteria 1
DLookup Alternative 11
Yet another DLookup problem! 5

Top