Do find in a calculation field

[Salin]

Hi,

I have 5 fields which contain color names. All 5 fields can have the same color or different colors. I often need to find one particula color in any of the 5 fields. So in find mode I enter a color name in field 1, and enter the same color name in the second field....then the 5th field. That's a very tedious job. If I needed to add other search components, it is not easy. I tried a calculation filed to combine all 5 fields. But when I do find from the calculation field, it finds nothing.

Here is my syntax. Hope someone could tell me what' wrong with it.

SearchColor = c1 & " " & c2 & " " & c3 & " " & c4 & " " & c5

Appreciate any help.

-Sal

[aldipalo]

I picked up a great 'Single Field' search technique from Matt Petrowsky at ISO Magazine. Since he charges $25.00 per qtr for access I don't feel it would be ethical to share it directly, But, here's the link.

http://www.filemakermagazine.com/videos/single-field-quick-search.html

Once implemented you can choose how many fields you wish to be searched and it will search them all. The great thing is that it is easily transportable to any layout or application.

I notice you are a beginner, I can tell you that between the forum and ISO I have had tremendous success building my application.

HTH