I have a customer form that opens when I click the MY Customers Button:Here is the code:DoCmd.OpenForm "CustomerF", , , "UserID=" & "Forms!MainMenuF!UserID".So the current user sees the records assign to them.
I also have a listbox and a combobox on the same form. When I choose from the combobox,  "active statuses", my listbox is populated with customers that have an "active status". When I double click an item in the listbox it populates that customers information on the form. The listbox is on the same form, side by side.Listbox on the left Customer Info On the right. When I clear the listbox, how do I see all of the current users assigned record again. The listbox is there so they can use the combobox to choose the customers they want to follow up with. When I clear the listbox I want to refresh the records to go back to the records that belong to the Current User. What I see for customer information is the info from the last customer I clicked on before I cleared the listbox.The record counter shows 1 of 1. The only way it seems to work is if I close the Customer form and then reopen the form again. Now the record counter sows 50 of 50. I want to clear the listbox and load all records again for the current user. 50 of 50. Hope this makes sense.

---

Reply from Alex Hedley:

Me.Filter = ""
Me.FilterOn = False