Dlookup Syntax

[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...

 

[Guest]

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

 

[Guest]

Hi,

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

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...

 

[Guest]

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.

Hi,

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

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...

 

[Guest]

done that...still not working...

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.

Hi,

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

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...