Dlookup Syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

i am trying to do a dlookup in Access 2002 but keep getting the
operand/operator error, this is my formula can anyone pls help....

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

pls can someone help...
 
Because you have spaces in your form name you need to put square brackets
around Forms![Form B_W Master Data]!MachineID
 
Hi,

I have done that but am still getting the same error, could it be the
spacing???

Dennis said:
Because you have spaces in your form name you need to put square brackets
around Forms![Form B_W Master Data]!MachineID

Manveer said:
Hi,

i am trying to do a dlookup in Access 2002 but keep getting the
operand/operator error, this is my formula can anyone pls help....

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

pls can someone help...
Click to expand...
Click to expand...
 
Take out the space after your square bracket & before Lima .... and put a
space after the & and before Forms![Form .....
This statement will only work as well if [System ID] and [Machine ID] are
both numeric.

manveer said:
Hi,

I have done that but am still getting the same error, could it be the
spacing???

Dennis said:
Because you have spaces in your form name you need to put square brackets
around Forms![Form B_W Master Data]!MachineID

Manveer said:
Hi,

i am trying to do a dlookup in Access 2002 but keep getting the
operand/operator error, this is my formula can anyone pls help....

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

pls can someone help...
Click to expand...
Click to expand...
Click to expand...
 
done that...still not working...

Dennis said:
Take out the space after your square bracket & before Lima .... and put a
space after the & and before Forms![Form .....
This statement will only work as well if [System ID] and [Machine ID] are
both numeric.

manveer said:
Hi,

I have done that but am still getting the same error, could it be the
spacing???

Dennis said:
Because you have spaces in your form name you need to put square brackets
around Forms![Form B_W Master Data]!MachineID

:

Hi,

i am trying to do a dlookup in Access 2002 but keep getting the
operand/operator error, this is my formula can anyone pls help....

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

pls can someone help...
Click to expand...
Click to expand...
Click to expand...
 
Back
Top