Problem with Dlookup function *12162008

[J.Alladien]

Hi guys,

I have a form"AANVRAAG_JETZZA2"(with underlaying table for values) with a
certain field (only numbers) named "POP" ,on this form I would like to
display in another field the values from another table of mine(TYPES) ;So
this is what I did:


=DLookUp("TYPE","TYPES","TYPE-ID=forms![AANVRAAG_JETZZA2]![POP]")

When I do this I get # error#

What Am I doing wrong!
Thanks in advance for the help!

 

[John W. Vinson]

Hi guys,

I have a form"AANVRAAG_JETZZA2"(with underlaying table for values) with a
certain field (only numbers) named "POP" ,on this form I would like to
display in another field the values from another table of mine(TYPES) ;So
this is what I did:


=DLookUp("TYPE","TYPES","TYPE-ID=forms![AANVRAAG_JETZZA2]![POP]")

When I do this I get # error#

What Am I doing wrong!
Thanks in advance for the help!

If the Data Type of TYPE-ID is in fact Text (even if its values are only
numeric digits) you need the syntactically required quotemarks. Since your
fieldname (unwisely, IMO) contains a special character - the hyphen - you
should also enclose it in square brackets. Try

=DLookUp("TYPE","TYPES","[TYPE-ID]= '" & [forms]![AANVRAAG_JETZZA2]![POP] &
"'")

 

[J.Alladien]

Hi John,

That did it thanks a lot

Hi guys,

I have a form"AANVRAAG_JETZZA2"(with underlaying table for values) with a
certain field (only numbers) named "POP" ,on this form I would like to
display in another field the values from another table of mine(TYPES) ;So
this is what I did:


=DLookUp("TYPE","TYPES","TYPE-ID=forms![AANVRAAG_JETZZA2]![POP]")

When I do this I get # error#

What Am I doing wrong!
Thanks in advance for the help!

If the Data Type of TYPE-ID is in fact Text (even if its values are only
numeric digits) you need the syntactically required quotemarks. Since your
fieldname (unwisely, IMO) contains a special character - the hyphen - you
should also enclose it in square brackets. Try

=DLookUp("TYPE","TYPES","[TYPE-ID]= '" & [forms]![AANVRAAG_JETZZA2]![POP] &
"'")