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