Hi!
I wish to allow to the user to select the name of a FIELD in a query from a combo box and have the query run and show only that field.
That is, a user could choose MATH101 from a combo box, which is the name of a yes/no field in a query. I added a button that assigns the name MATH101 to a temporary variable, then opens the queyr which references the MATH101 in the Field: line of the query. Of course, that just displays MATH101 in the query, instead of looking up the yes/no value for the field called MATH101.
Is there any way to dynamically make access understand that I only want to see that field in my query? It is a huge table and I want my admin to only see that one field of her choice.
Any tips would be super! Or, alternatively, let me know what to search for in this forum.
Thanks!
Melody
I wish to allow to the user to select the name of a FIELD in a query from a combo box and have the query run and show only that field.
That is, a user could choose MATH101 from a combo box, which is the name of a yes/no field in a query. I added a button that assigns the name MATH101 to a temporary variable, then opens the queyr which references the MATH101 in the Field: line of the query. Of course, that just displays MATH101 in the query, instead of looking up the yes/no value for the field called MATH101.
Is there any way to dynamically make access understand that I only want to see that field in my query? It is a huge table and I want my admin to only see that one field of her choice.
Any tips would be super! Or, alternatively, let me know what to search for in this forum.
Thanks!
Melody