Creating SQL query taking the field name from a text box

[jahansam]

Hi, in MS Access I want to create a SQL query where field name can be taken from a text box or combobox. For example, I have a table name "bank" and it has fields "Customer_id","Cust_name","transaction". I want to display all transactions of customer "John". So I have two text boxes to provide the field name and the customer name. I want to make an SQL query to display the results but I don't want to provide the field/column name directly to the SQL command instead using text box. Can anyone help me please?

I don't want to write : SELECT Cust_name, transaction from bank where Cust_name = "John"

I want like : SELECT (text1.value),transaction from bank where (text1.value) = (text2.value)

[NeoPa]

SQL commands are basically strings.

Do you need specific instructions on how to work with strings or does that give you enough of a clue to get you going?

[jahansam]

Well, I want to see that the SQL gives me the records of transaction matching with the name "John". So, later I can use other field name without changing the SQL command.

[NeoPa]

I expect you do, but that doesn't answer my question. I'm ready to help but we need to converse sensibly for that to happen.