dlookup to return a list of values

[Alex]

I have a hidden form control named "refpart" with a dlookup function in a
control that I know will return only one value (works fine). I have another
hidden control on the same named "listrefparts" form that I also need to
return values, but it will return several values. I have a third text box
control with data: Iif [refpart] = [listrefparts],"yes","no). I need to
return true if "refpart" is equal to any of the values listed in
"listrefparts". How can I get "listrefparts" to create a list for "refpart"
to compare to? Thanks.

 

[Duane Hookom]

Use the generic concatenate function from
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane which can
place multiple values in a single text box. You can then use InStr() to
determine if one value in found in the other.