Issue with DLookup

[NewProgramPerson]

Hi:
I am having a hard time getting DLookup to work. I enter =DLookUp("Lens Type",[Start New Plate]) into the control source of a form, because I want to return a Lens type from the Start New Plate table. I get #Name? returned. I've tried changing the brackets and quotation marks, but I still get the same error. What am I missing? As you've guessed, I'm not a programmer, so I guess I'm missing something basic.


Thank you

[davegri]

Dlookup("[Lens Type]","[Start New Plate]")
All the arguments need to be in quotes. Object names containing spaces need brackets.

[Missinglinq]

Is there only one Record in [Start New Plate]? If not, where is your Criteria portion of the Function?

If you have multiple Records in [Start New Plate] and don't use a Criteria (aka a Where statement) DLookup() will return a random value from a random Record.

Or is that the idea?

Linq ;0)>

[NewProgramPerson]

Dlookup("[Lens Type]","[Start New Plate]")
All the arguments need to be in quotes. Object names containing spaces need brackets.

Awesome. Worked like a champ.
Thank you

[NewProgramPerson]

Hi:
One more question: I added the criteria at the end, so the statement is now: =DLookUp("[Process Flow:]","[Start New Plate]","[Plate Number:]"="[Plate No:]"). I'm want to return the Process Flow: from the Start New Plate table, where the Plate Number: in the Start New Plate table equals the Plate No: in my table. What's wrong with the criteria?
Thanks

[NewProgramPerson]

And one more question: Where is a good source for this information on the DLookup structure (and other Access commands)? If you have any advice here, it would be appreciated.
Thanks again,

[davegri]

I'm want to return the Process Flow: from the Start New Plate table, where the Plate Number: in the Start New Plate table equals the Plate No: in my table. What's wrong with the criteria?

equals the Plate No: in my table

What table is that? Surely not [Start New Plate].

The syntax would be

DLookUp("[Process Flow:]","[Start New Plate]","[Plate Number:]=" & [Plate No:])

This assumes that [Plate No:] is a field in the recordsource for the form or a control on the form, like a combo box. It also assumes that [Plate No:] is numeric. It also assumes a couple of other things, which may or may not apply in this case.
Bye the way, including special characters in data names (like colon() is not a good idea, as well as having spaces in data names is a bad idea. It can lead to complications that can be difficult to diagnose, so avoidance is best practice.

You may have some design problems that can only be diagnosed by seeing a copy of your DB.

[June7]

Google: Access domain aggregate function. http://blueclaw-db.com/domain_aggregate_function/

Or buy a reference book.

[NewProgramPerson]

What table is that? Surely not [Start New Plate].

The syntax would be

DLookUp("[Process Flow:]","[Start New Plate]","[Plate Number:]=" & [Plate No:])

This assumes that [Plate No:] is a field in the recordsource for the form or a control on the form, like a combo box. It also assumes that [Plate No:] is numeric. It also assumes a couple of other things, which may or may not apply in this case.
Bye the way, including special characters in data names (like colon() is not a good idea, as well as having spaces in data names is a bad idea. It can lead to complications that can be difficult to diagnose, so avoidance is best practice.

You may have some design problems that can only be diagnosed by seeing a copy of your DB.

[Plate No:] is actually a short text field, not numeric. What changes would I need to accommodate for this?
Thanks

[pbaldy]

[Plate No:] is actually a short text field, not numeric. What changes would I need to accommodate for this?
Thanks

http://www.theaccessweb.com/general/gen0018.htm

[davegri]

If [Plate No:] is not numeric it needs to include single quotes:

DLookUp("[Process Flow:]","[Start New Plate]","[Plate Number:]='" & [Plate No:] & "'")

[NewProgramPerson]

http://www.theaccessweb.com/general/gen0018.htm

Thanks, I'll take a look.

[NewProgramPerson]

Appreciate the help.