use parameter in field name of select query

[focosi]

Let's assume I have Form1 with "hello" in TxtField1.
Now I have a select query with a field named "ID".
Is it possible to rename "ID" as parameter "hello" ? I have tried inputting in SQL "OriginalQueryFieldName AS [Forms]![Form1]![TxtField1]" but it is not accepted.

Another point is : can I use the parameter "hello" in the query caption ?

[orange]

Are you trying to use a field value on your form to filter a query?

"SELECT a,b,c from MyTable WHERE myField = '" & [Forms]![Form1]![TxtField1] & "'"

[focosi]

No, I am using a field value to name the field name (very top row) or the caption (window name) in a query. Is it possible ??