I've seen this question posted elsewhere, but I can't make any of the answers work (I'm a beginner with Access).
I have a combobox that lets you select an employee, which gives the selected employee name as the parameter for a query. I want to have a "Select All" option in the combobox that tells the query to use all employees. This is my current Row Source code for the combobox:
SELECT [Employee Directory].[ID], [Employee Directory].[Employee Name] FROM [Employee Directory] ORDER BY [Employee Name];
I've tried a couple different solutions from other threads--including adding UNION--but can't make it work. I also don't know if code needs to be added elsewhere as well. How do I make this work?
I have a combobox that lets you select an employee, which gives the selected employee name as the parameter for a query. I want to have a "Select All" option in the combobox that tells the query to use all employees. This is my current Row Source code for the combobox:
SELECT [Employee Directory].[ID], [Employee Directory].[Employee Name] FROM [Employee Directory] ORDER BY [Employee Name];
I've tried a couple different solutions from other threads--including adding UNION--but can't make it work. I also don't know if code needs to be added elsewhere as well. How do I make this work?