DLookup

[samotek via AccessMonster.com]

I have a table of only 2 fields clientid and note.This field is memo.I tried
to make a DLookup control in my form but i cannot get the result.What is the
reason ? The unbound control in my form i have written as folllows:
=DLookUp("[notes]";"NotesToContacts")

 

[bhicks11 via AccessMonster.com]

Hi Samotek,

Your DLookup is missing elements. You need:

DLookup(Whatyouarelookingup, TableorQueryyouarelookingin, criteria)

Example:

DLookup("[LastName]", "Employees", "[EmployeeID] = 1")

Bonnie
http://www.dataplus-svc.com

I have a table of only 2 fields clientid and note.This field is memo.I tried
to make a DLookup control in my form but i cannot get the result.What is the
reason ? The unbound control in my form i have written as folllows:
=DLookUp("[notes]";"NotesToContacts")

 

[samotek via AccessMonster.com]

Thank you !!!!

Hi Samotek,

Your DLookup is missing elements. You need:

DLookup(Whatyouarelookingup, TableorQueryyouarelookingin, criteria)

Example:

DLookup("[LastName]", "Employees", "[EmployeeID] = 1")

Bonnie
http://www.dataplus-svc.com

I have a table of only 2 fields clientid and note.This field is memo.I tried
to make a DLookup control in my form but i cannot get the result.What is the
reason ? The unbound control in my form i have written as folllows:
=DLookUp("[notes]";"NotesToContacts")

 

[samotek via AccessMonster.com]

Thank you for your advice. I have built the DLookup wth the criteria but i
get the message error.
Will you help ?

=DLookUp(" note";"NotesToContacts";" [clientid]=[Me]![clientid]")

Hi Samotek,

Your DLookup is missing elements. You need:

DLookup(Whatyouarelookingup, TableorQueryyouarelookingin, criteria)

Example:

DLookup("[LastName]", "Employees", "[EmployeeID] = 1")

Bonnie
http://www.dataplus-svc.com

I have a table of only 2 fields clientid and note.This field is memo.I tried
to make a DLookup control in my form but i cannot get the result.What is the
reason ? The unbound control in my form i have written as folllows:
=DLookUp("[notes]";"NotesToContacts")

 

[Paolo]

Hi samotek,
you must leave outside the quotation marks the variable [Me]![clientid] i.e.

=DLookUp(" note";"NotesToContacts";" [clientid]=" & [Me]![clientid])

If you leave it between the quotation marks it will be interpreted by access
as a string.

HTH Paolo

Thank you for your advice. I have built the DLookup wth the criteria but i
get the message error.
Will you help ?

=DLookUp(" note";"NotesToContacts";" [clientid]=[Me]![clientid]")

Hi Samotek,

Your DLookup is missing elements. You need:

DLookup(Whatyouarelookingup, TableorQueryyouarelookingin, criteria)

Example:

DLookup("[LastName]", "Employees", "[EmployeeID] = 1")

Bonnie
http://www.dataplus-svc.com

I have a table of only 2 fields clientid and note.This field is memo.I tried
to make a DLookup control in my form but i cannot get the result.What is the
reason ? The unbound control in my form i have written as folllows:
=DLookUp("[notes]";"NotesToContacts")