DLookup 1

[samotek]

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")

 

[TheAceMan1]

How are ya samotek . . .

There's no crireria to say which record! Have a look at the [blue]third arguement[/blue] of DLookUp.

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[samotek]

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]")

 

[TheAceMan1]

samotek . . .

Don't think it matters but there's an uneeded space:

[blue]"[COLOR=black red] [/color][clientid]=[Me]![clientid]"[/blue]

If ClientID is text criteria should be:

[blue]"[clientid] = '" & [Me]![clientid] & "'"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886