The following event procedure displays only Illinois customers in the Customers and Prospects lookup window:
Private Sub Grid_BeforeLinePopulate(RejectLine As Boolean) If State <> "IL" Then RejectLine = True End If End Sub