I have a multiple select list box on a pop-up form. The list box contains the following columns: EmployeeID, FirstName And LastName.
I need the database user to be able to select all the employees they are interested in and click a command button on the pop-up form to filter my main form.
The user can now update the filtered records and use the command buttons on the main form to cycle through them, until every record has been updated. Once the update is completed the user would need to remove the filter by selecting another command button on the main form.
I have no programming experience and need to know what code should be inserted in the click event property of the command button on the pop-up form to filter the main form and what code would I need to remove the filter?
My thanks in advance.