DLookup syntax

[kattatonic1]

I'm having a syntax error trying to get a value into a textbox on a form.

This is what I think should work:


=DLookUp([Input Constants]![Value],[Input Constants],[Input Constants]![Constant]='Test')

[Input Constants] is my table
[Value] is field that contains the number I wish to return; it is a number field
[Constant] is the field for the criteria test; it is text

I've tried what seems every syntax permutation but I continue to get #Name? or a blank returned.

Please help.

Kay
from Toronto

[June7]

The arguments must be within quotes.

=DLookUp("[Value]", "[Input Constants]", "[Constant]='Test'")

If you want the criteria to be dynamic by reference to another field or control, concatenate the variable.

=DLookUp("[Value]", "[Input Constants]", "[Constant]='" & [controlname here] & "'")

Access Help has more info on using domain aggregate functions. However, these functions can perform slowly in queries, forms, reports. There are options that work better. Just depends on your data and form design.


NOTE: I split your post to a new thread. Thread hijacking is discouraged. If you want your question to receive maximum attention, start a new thread and reference the old thread if you think it helps explain yours.

[orange]

Techonthenet has all sorts of syntax and examples of Access functions.
http://www.techonthenet.com/access/f...in/dlookup.php

[kattatonic1]

Thank you, June7! I tried quotes but I think I had the last expression as "[Constant]"='Test'). Now I see the point of "[Constant]='Test'"). I'll also use the dynamic technique in this database; I'm sure!

So regarding the thread-jacking, I thought keeping similar questions together was useful but I see what you mean! Sorry to cause you work.

orange -- Nice reference page, thanks! I will use that too.

Kay
from Toronto