Issue with AlphaNumberic Strings

[NewProgramPerson]

Hi:



I use the following code to pass a string called Lens Type: from Start New Plate table to the current table

=DLookUp("[Lens Type:]","[Start New Plate]","[Lens Type:]='" & [Lens Type:] & "'")

It works well when the Lens Type: is all letters, but I have one string that contains both letters and numbers (string is MK5 Test). It won't pass this string. It will ignore it or pass a different string that is only letters. What am I doing wrong?

Thanks

[Micron]

I don't see how that works at all. You're saying Look up lens type in table Start New Plate where lens type = 'some value'
If you know what 'lens type' is (because after all, you are passing a value as criteria) then there's nothing to look up.
It shouldn't matter that the field contains letters and numbers as long as the field is text data type and the expression syntax is correct. What should matter is that the criteria and the value being looked up are not the same.

[ssanfu]

Also be aware that your field naming is very poor.

Use only letters and numbers (exception is the underscore) for object names.
Do not use spaces, punctuation or special characters in object names.
Do not begin an object name with a number.
Do not/should not use Look up FIELDS, multi-Value fields or Calculated fields in tables.


Examples
----------
Bad - Lens Type:
Better - LensType or Lens_Type

[ranman256]

you cannot use brackets as a param.
if you are using a form, rename the textbox to txtType, then

=DLookUp("[Lens Type:]","[Start New Plate]","[Lens Type:]='" & txtType & "'")

(and yes, never use spaces nor colons in your field names.)

if you are using a query, DONT use dlookup. Use a join to the lookup table.

[Bulzie]

Maybe try 3 quotes on left and 4 on right "[Lens Type:]=""" & [Lens Type:] & """") or

Maybe use string convert function "[Lens Type:]='" & CStr([Lens Type:]) & "'") Not sure if it will work in the line, might have to do like x = CStr([Lens Type:]), then in the line use "[Lens Type:]='" & x & "'")

so Lens Type: is the name of your field in the table?