G
Guest
Hi All,
Thanks so much to anyone who might be able and willing to help me
Can i somehow pass data, from a form to a query, that represents the field
name,
that the query will use to retrieve specific data, from a table?
A value (which represents a question number) is set in my form. Let's say
that the value is "Q2".
The string variable to which this value is assigned is: strQuestionNum and
it is passed to a query.
tblSurveyResponses, is a table, used in the query. This table is populated
with data from an imported text file.
One of the FIELDS in tblSurveyResponses is named Q2, and that field contains
text representing a user's response to question number 2.
I know that the query is receiving the strQuestionNum - I've tested that
much. But I cannot figure out how to tell the query that i want the value of
strQuestionNum to be used as the field name.
I tried getting the data, in the query, by using the eval statement - but
access doesn't like that.
(query grid field expression being set to: ShowThis:
tblSurveyResponses.eval("Forms!frmSurvey!strQuestionNum")
I tried using various brackets and it doesn't help.
Thanks for taking the time to view my problem!
Thanks so much to anyone who might be able and willing to help me
Can i somehow pass data, from a form to a query, that represents the field
name,
that the query will use to retrieve specific data, from a table?
A value (which represents a question number) is set in my form. Let's say
that the value is "Q2".
The string variable to which this value is assigned is: strQuestionNum and
it is passed to a query.
tblSurveyResponses, is a table, used in the query. This table is populated
with data from an imported text file.
One of the FIELDS in tblSurveyResponses is named Q2, and that field contains
text representing a user's response to question number 2.
I know that the query is receiving the strQuestionNum - I've tested that
much. But I cannot figure out how to tell the query that i want the value of
strQuestionNum to be used as the field name.
I tried getting the data, in the query, by using the eval statement - but
access doesn't like that.
(query grid field expression being set to: ShowThis:
tblSurveyResponses.eval("Forms!frmSurvey!strQuestionNum")
I tried using various brackets and it doesn't help.
Thanks for taking the time to view my problem!