I have a form that shows all records in a query, one field is called ProductType, In the header I have an unbound combo box that gets records from the product type table and filters the detail section of the form (all records) to the selection in the combo box. All is working fine but once i select the field in the combo box it filters as it should but the combo box is blank, is there a way to keep the selection visible after being selected?
Also is there a way to add "All" or "Clear Filter" to the combo box?
Thanks
Also is there a way to add "All" or "Clear Filter" to the combo box?
Thanks