>>Sounds like you want a parameterized view for the company, then a requery for the grid view.
>
>Sounds good. How do I make the parameter "dynamic", thus "Company='ABC Firm' when 'ABC Firm' is the current Company record?
>
I see Dave is trying to get you moving too...if there's still a problem with that, or you want to do the param. view for another reason, after adding the param. to your view (with designer, if you're using it), you could set it to the textbox value in its lostfocus and do the requery there as well...