Create a UserForm

[Pestomania]

I have a Query on Access that contains a column of initals. Currently the purpose of this report is to print based on the initials criteria and then go to the next. Is there a way to create a "USERFORM" that has two columns. One that contains all unique values from the selected column and then one on the right that is empty. In the center would be the "ADD" "REMOVE" buttons that allow you to select the unique values. Once added to the other side, a button can be pressed to cycle through those initals and print the corresponding reports without user interface.

Is it possible to have the USERFORM pull it's options from a query field? If so, how would I? If not, any ideas or suggestions?

Thank you

Link to an example of the list box (https://www.excel-easy.com/vba/examples/multiple-list-box-selections.html)

 

[xenou]

Access doesn't have userforms. Add MSACCESS to your searches to get results for Access, not Excel.
This is one site that explains a process similar to what you are describing:
https://www.youtube.com/watch?v=n0ykubD6e8g

In general this is simply an extension of working with listboxes to add or remove items so you want to search for MSAccess ListBox add item and MSAccess ListBox remove item (perhaps, selected item more specifically). The buttons will just trigger the code so you put the code in the button click events.