>Hi all...
>
>Is it possible to use a variable in place of a field name in a select statement?
>
>My form will have a combo box from which the user can select a number of different options each of which refers to a different field in the same table. The user then can enter text in a text box which represent what they want to find in that field.
>
>So, when they click a button (like "Find"), the following is executed:
>
>VarFieldName = thisform.cmbField.value
>VarFieldText = thisform.txtField.value
>select * from table_name where table_name.VarFieldName = VarFieldText
>
>I get the following error:
>SQL: Column 'VARFIELDNAME' is not found.
>
>It would appear that VFP is not substituting my variable name for the field with the "real" field name.
>(Gosh, I amaze myself sometimes! <g>)
>
>Any suggestions? ( I mean, other than creating a series of if/endif for every possible value in the combo box.)
>
>tia,
>
>marc mandel

Marc,

If this is going to be a view that is used over and over, you might consider defining it as a local view in the database using the view designer. The designer allows you to add variables.

Your select statement could look like this;

select * from table_name where ?thisform.cmbField.Value = ; ?thisform.txtField.value

Steve