I think the QBF would give me select records for whichever fields I chose to base my query (presuming multiple text boxes, each representative of the different fields), but all the other fields would show up as well, and/or I would have to set up >50 text boxes for the fields.
I am trying to have only two columns displayed in the Query design view (and ultimately a report): the WorkerInitials field, and then the other field, which would be based on the field selected in a combo box populated by a field list, and show all records
This probably isn't what you want, but you could write all the required scripts and use the drop down list to chose which one run via a switch case in vba. Which of course is a lot of work and not a nice compact answer.
An alternative would be to pass the name of the field selected to a vba script which then used concatenation to construct the desired sql from existing bits and then ran it.