I have a listbox in a form that populates automatically with a specific field name from a table after the user chooses from a series of other list boxes. I would like to use this final outcome as the Field data for a query that would be executed by the user. How can I get this information into the Field box of my query designer? I'm aware that using [Forms]![formName]![listBox123] is a way to pull data into the criteria box. Is there something similar to pull the same data into the Field box?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!