Hi Alex,
I have managed to use the code you cleaned up and it works well except for the fact that the text boxes dont show the result of the Dcount code until I click in the box. I tried to delete and paste it back in but it still does the same thing. The other problem Ive noticed is that if I use my "quick search" box, the one built in the Search Seminar it works fine but when I click on the "my customers" button to go back to my exclusive customers I get "Run-time error '2501'
The OpenForm action was canceled.?
Thanks

---

Reply from Alex Hedley:

Are there always customers to show?
Does the button just change the filter or is that one that updates the SQL and RecordSource?