>Hi, all!
>
>I've been working a problem I've had with creating an application for some time and now think that I'm in a position to ask an intelligent question about my problem. (Yeah, right!)
>
>My application will have a list box which contains a set of field names and a text box in which the user will enter the information for which they want to search in the database.
>
>I want to capture both of these two variables (say, for example, varFieldName and varSearchText) and then use those variables to search. (I'm acually using a view I created of the database, which was suggested by someone on this forum.)
>
>The reason I want to do this, instead of placing it in the query, is that I eventually want to have multiple instances of these listbox/textbox pairs, and I don't want to have every combination of if/then code in my "Find" command button. Three listbox/textbox pairs and 8 fields = 3^8 possible combinations.
>
>The variable for the text (varSearchText) works fine, but not the one for the FieldName(varFieldName).
>
>If it helps, I've captured the screen from Form Designer and View Designer and placed it on my home page http://www.usd.edu/~mmandel/vfp.htm).
>
>Is there a way to make the second method work or should I submit myself for a drug test?
>
>tia,
>
>marc mandel


LOL
Don't you know that drug-testing is mandatory for VFP programmers now.
( PUI - programming under the influence )

Actually, I'll check out your web-site. Have you seen the wiz-style
find. Check this out and if you could increase these to 3 choices as
opposed to two, would this work for you?

Dan