Guys I am looking to return data from a query using a form that has multi select list boxes on it.
What I want to happen is I open my form (Main_Menu) select my details and double click the list box (lstCategory) gets populated I then double click the (lstEmpCat) which also populates I choose from the list my multiple selections and then press the button (Preview) on pressing this I want the query (Build) to populate based on this but I am needing some assistance.
Can any one help
I will attach the database to help.
to help you understand the list box (lstCategory) refers to the column in my query (PAYROLL_LIST_ID) and the list box (lstEmpCat) refers to the column in my query (EMP_CAT_NAME)