SDRichardC
Technical User
I have created a query underlying to a button OnClick event.
There is two list box that I want to set the criteria for. There is a date criteria coded: Between [Forms]![frmDetailQuery]![DateFrom] And Forms]![frmDetailQuery]![DateTo]. Then the two Unbound listbox that I want to set for a multiselect are called TS and Iss. I looked at the properties and set the multiselect to simple and not sure if there is other places that I may have missed. The button name is called "View Data". I want the user to set the date range, select items from the "TS" and "Iss" listbox, multi items if they want and have the query return those information. How can I go about in doing so.
There is two list box that I want to set the criteria for. There is a date criteria coded: Between [Forms]![frmDetailQuery]![DateFrom] And Forms]![frmDetailQuery]![DateTo]. Then the two Unbound listbox that I want to set for a multiselect are called TS and Iss. I looked at the properties and set the multiselect to simple and not sure if there is other places that I may have missed. The button name is called "View Data". I want the user to set the date range, select items from the "TS" and "Iss" listbox, multi items if they want and have the query return those information. How can I go about in doing so.