>Thanks for that.
>
>That was the sort of thing I was going to put in. I have noticed that when opening Views it can take a while, but when you just requery them, it's pretty quick.
>
>I do, however, have one more snag, and that is the fact that the buttons used to open my Container screens, highlight in BLUE if there is data behind them - I can't think of a way of getting around that without running more Select statements!!
>
>Kev

Create a parameterized SQL view based on something like the following.

Create SQL View lv_Kounts as ;
   select ;
      sum(iif(ID = ?cValue1, 1, 0)) Kount1, ;
      sum(iif(ID = ?cValue2, 1, 0)) Kount2, ;
      sum(iif(ID = ?cValue3, 1, 0)) Kount3 ;
      from MyTable

Your buttons would be BLUE/Enabled if the correcponding KountX field is greater than 0.